linq2db.LINQPad/release-notes.md

14 KiB

Release 5.4.2

Changes:

  • update dependencies
  • #120: re-enable DB2 iSeries provider support. Thanks to Marcus Hellsten for PR

Release 5.4.1

Update dependencies (#113, #114)

Release 5.2.2

Fix nuget dependencies

Release 5.2.1

DELISTED

Issues fixed:

  • #109: fix dependency issues in 5.2.0 release

Release 5.2.0

DELISTED

Issues fixed:

  • #88: add support for LINQPad Password Manager in connection strings. To reference value from password manager use {pm:password-name} token syntax
  • #97, #103: update dependencies to get rid of vulnerable transient dependencies
  • #101: fix snippets generation from object names matching C# keywords
  • #102: support custom IDataContext-based contexts; don't try to load missing connection configuration files. Thanks to @cal-tlabwest for fix
  • #106: ensure we use invariant culture with strings

Release 5.1.0

Issues fixed:

  • #89, #90: add scaffold option to use database object names as-is

Release 5.0.0

Complete driver rewrite:

  • complete redesign of configuration dialog
  • LINQPad 6 support dropped (you can still use 4.x versions of driver with LINQPad 6)
  • migrateed dynamic context code-generation to new scaffolding framework
  • implemented Close all connections functionality for Access, DB2 LUW, DB2 z/OS, Firebird, Informix, MySql, Oracle, PostgreSQL, SAP HANA, SQLite, SAP/Sybase ASE connections (previous versions implemented only SQL Server support)
  • implement automatic schema refresh for Access (OLE DB provider only), ClickHouse, DB2 LUW, DB2 z/OS, MySql, MariaDB, SAP HANA, Oracle and SAP/Sybase ASE (previous versions implemented only SQL Server support)
  • added LinqToDB, LinqToDB.Data and LinqToDB.Mapping usings to queries also for static context driver
  • stored procedures and functions schema load options now allow you to select which routine types to load (e.g. only stored procedures)
  • add additional connection string support for Access to mitigate schema issues in ODBC and OLE DB providers
  • show packages in schema tree for supporting databases
  • add nullability information for columns and parameters for both value and reference types
  • add SQL dialog selection for databases for which Linq To DB supports multiple dialects
  • [LINQPAD5] rise required framework version from .NET Framework 4.6.1 to 4.8
  • [LINQPAD7] raise required framework version from netcoreapp3.1 to net6.0-windows
  • [LINQPAD7] add .NET 7 and 8 support
  • [LINQPAD5] strong name removed from driver. Because LINQPad 5 use fully-qualified assembly name to store connection settings, your old connections will not be visible in LINQPad 5 with new driver and should be recreated (or you could try to edit assembly name in LINQPad settings file for old connections)
  • [LINQPAD5] add support for connection configuration load from json files for static contexts
  • [LINQPAD7] add support for connection configuration load from app.config files for static contexts

Issues fixed:

  • #58: fixed raw SQL execution support for all databases
  • #79: added ClickHouse support using MySql, HTTP(s) and binary protocols

Changes to dependencies (except version bumps):

  • removed: Humanizer.Core
  • removed: CodeJam
  • [ALL] new: linq2db.Tools
  • [ALL] new: ClickHouse.Client
  • [ALL] replaced: System.Data.SqlClient -> Microsoft.Data.SqlClient
  • [LINQPAD5] new: System.Text.Json
  • [LINQPAD7] new: Octonica.ClickHouseClient
  • [LINQPAD7] replaced: IBM.Data.DB2.Core -> Net.IBM.Data.Db2
  • [LINQPAD7] replaced: dotMorten.Microsoft.SqlServer.Types -> Microsoft.SqlServer.Types

Release 4.2.0

  • [ALL] dependency update: linq2db 4.1.0 -> 4.2.0
  • [DEPS][ALL] dependency update: MySqlConnector 2.1.10 -> 2.1.13
  • [DEPS][LINQPAD7] dependency update: Microsoft.CodeAnalysis.CSharp 4.2.0 -> 4.3.0
  • [DEPS][LINQPAD7] dependency update: FirebirdSql.Data.FirebirdClient 7.10.1 -> 9.0.1
  • [DEPS][LINQPAD7] dependency update: Npgsql 6.0.5 -> 6.0.6
  • [DEPS][LINQPAD7] dependency update: Oracle.ManagedDataAccess.Core 3.21.61 -> 3.21.70

Release 4.1.1

  • [LINQPAD7] nuget spec bugfix

Release 4.1.0

  • [ALL] dependency update: linq2db 4.0.1 -> 4.1.0
  • [LINQPAD7] dependency update: Npgsql 6.0.4 -> 6.0.5
  • [LINQPAD7] dependency update: System.Text.Json 6.0.4 -> 6.0.5

Release 4.0.0

  • #63 Update Oracle.ManagedDataAccess.Core dependency to fix warning (thanks @db2222)
  • #65 Fix bug in pluralization/singularization code
  • [ALL] dependency update: linq2db 3.6.0 -> 4.0.1
  • [ALL] dependency update: LINQPAD.Reference 1.1.0 -> 1.3.0
  • [ALL] dependency update: Humanizer.Core 2.13.14 -> 2.14.1
  • [ALL] dependency update: CodeJam 4.0.1 -> 4.1.0
  • [ALL] dependency update: System.Memory 4.5.4 -> 4.5.5
  • [ALL] dependency update: MySqlConnector 2.0.0 -> 2.1.10
  • [ALL] dependency update: System.Data.SQLite.Core 1.0.115.5 -> 1.0.116
  • [LINQPAD7] dependency update: Oracle.ManagedDataAccess.Core 3.21.4 -> 3.21.61
  • [LINQPAD7] dependency update: IBM.Data.DB2.Core 3.1.0.500 -> 3.1.0.600
  • [LINQPAD7] dependency update: dotMorten.Microsoft.SqlServer.Types 1.3.0 -> 1.5.0
  • [LINQPAD7] dependency update: Microsoft.CodeAnalysis.CSharp 4.0.1 -> 4.2.0
  • [LINQPAD7] dependency update: Npgsql 6.0.0 -> 6.0.4
  • [LINQPAD7] dependency update: FirebirdSql.Data.FirebirdClient 8.5.4 -> 9.0.1
  • [LINQPAD7] dependency update: System.Text.Json 6.0.0 -> 6.0.4
  • [LINQPAD5] dependency update: Oracle.ManagedDataAccess 19.13.0 -> 19.14.0

Release 3.6.0

  • starting from this release we use LINQPad 7 instead of 6 for testing, so LINQPad 6 compatibility not guaranteed
  • #57 use stable ordering of custom context properties. Thanks to @RoyChase for fix
  • [ALL] dependency update: linq2db 3.3.0 -> 3.6.0
  • [ALL] dependency update: CodeJam 3.3.1 -> 4.0.1
  • [ALL] dependency update: MySqlConnector 1.3.5 -> 2.0.0
  • [ALL] dependency update: System.Data.SQLite.Core 1.0.113.7 -> 1.0.115.5
  • [ALL] dependency update: System.Data.SqlClient 4.8.2 -> 4.8.3
  • [ALL] dependency update: Humanizer.Core 2.8.26 -> 2.13.14
  • [ALL] dependency update: System.Runtime.CompilerServices.Unsafe 5.0.0 -> 6.0.0
  • [LINQPAD5] fix DB2/Informix provider load issue
  • [LINQPAD5] dependency update: Npgsql 4.1.8 -> 4.1.10
  • [LINQPAD5] dependency update: IBM.Data.DB.Provider 11.5.4000.4861 -> 11.5.5010.4
  • [LINQPAD5] dependency update: Oracle.ManagedDataAccess 19.11.0 -> 19.13.0
  • [LINQPAD7] dependency update: FirebirdSql.Data.FirebirdClient 8.0.1 -> 8.5.4
  • [LINQPAD7] dependency update: System.Configuration.ConfigurationManager 5.0.0 -> 6.0.0
  • [LINQPAD7] dependency update: Microsoft.CodeAnalysis.CSharp 3.9.0 -> 4.0.1
  • [LINQPAD7] dependency update: System.Data.Odbc 5.0.0 -> 6.0.0
  • [LINQPAD7] dependency update: System.Data.OleDb 5.0.0 -> 6.0.0
  • [LINQPAD7] dependency update: Npgsql 5.0.4 -> 6.0.0
  • [LINQPAD7] dependency update: Oracle.ManagedDataAccess.Core 3.21.1 -> 3.21.4
  • [LINQPAD7] dependency update: IBM.Data.DB2.Core 3.1.0.400 -> 3.1.0.500
  • [LINQPAD7] dependency update: System.Text.Json 5.0.2 -> 6.0.0
  • [LINQPAD7] add readme to nuget
  • [INFRASTRUCTURE] enable C# 10 support
  • [INFRASTRUCTURE] use net6.0 build target to validate code against recent NRT definitions

Release 3.3.3

  • [ALL] disable load of procedures and functions by default for new connections
  • [ALL] dependency update: MySqlConnector 1.3.2 -> 1.3.5
  • [ALL] initial support for Firebird 4 types
  • [ALL] fix issue with command timeout option being ignored (#47)
  • [LINQPAD6] dependency update: FirebirdSql.Data.FirebirdClient 7.10.1 -> 8.0.1
  • [LINQPAD6] improve fix for #39
  • [LINQPAD6] support connection configuration using appsettings.json for typed data context (#38)

Release 3.3.1

  • [LINQPAD6] fix incorrect versions for dependencies in nuget version of driver

Release 3.3.0

  • [ALL] dependency update: linq2db 3.2.3 -> 3.3.0
  • [ALL] dependency update: MySqlConnector 1.3.1 -> 1.3.2
  • [LINQPAD5] dependency update: Oracle.ManagedDataAccess 19.10.1 -> 19.11.0
  • [LINQPAD6] dependency update: Npgsql 5.0.3 -> 5.0.4

Release 3.2.0

  • codebase switched to C# 9
  • [ALL] "Allow multiple queries" option removed from connection configuration screen (has no effect with recent linq2db versions)
  • [ALL] fixed issue with typed data context load (#39)
  • [LINQPAD5] .net framework version updated from 4.6.0 to 4.6.1
  • [LINQPAD6] fixed issue with wrong TFM used for provider assembly
  • [ALL] dependency update: linq2db 3.1.4 -> 3.2.3
  • [ALL] dependency update: CodeJam 3.2.0 -> 3.3.1
  • [ALL] dependency update: AdoNetCore.AseClient 0.18.0 -> 0.19.2
  • [ALL] dependency update: FirebirdSql.Data.FirebirdClient 7.5.0 -> 7.10.1
  • [ALL] dependency update: MySqlConnector 1.0.1 -> 1.3.1
  • [ALL] dependency update: System.Data.SQLite.Core 1.0.113.1 -> 1.0.113.7
  • [LINQPAD5] dependency update: System.Runtime.CompilerServices.Unsafe 4.7.1 -> 5.0.0
  • [LINQPAD5] dependency update: IBM.Data.DB.Provider 11.5.4000.4 -> 11.5.4000.4861
  • [LINQPAD5] dependency update: Oracle.ManagedDataAccess 19.9.0 -> 19.10.1
  • [LINQPAD5] dependency update: Npgsql 4.0.11 -> 4.1.8
  • [LINQPAD6] dependency update: Microsoft.CodeAnalysis.CSharp 3.7.0 -> 3.9.0
  • [LINQPAD6] dependency update: System.Configuration.ConfigurationManager 4.7.0 -> 5.0.0
  • [LINQPAD6] dependency update: Oracle.ManagedDataAccess.Core 2.19.90 -> 3.21.1
  • [LINQPAD6] dependency update: System.Data.Odbc 4.7.0 -> 5.0.0
  • [LINQPAD6] dependency update: System.Data.OleDb 4.7.1 -> 5.0.0
  • [LINQPAD6] dependency update: IBM.Data.DB2.Core 3.1.0.300 -> 3.1.0.400
  • [LINQPAD6] dependency update: dotMorten.Microsoft.SqlServer.Types 1.2.0 -> 1.3.0
  • [LINQPAD6] dependency update: Npgsql 4.1.5 -> 5.0.3

Release 3.1.0

  • [ALL] dependency update: linq2db 3.0.1 -> 3.1.4
  • [ALL] dependency update: CodeJam 3.1.0 -> 3.2.0
  • [ALL] dependency update: System.Data.SqlClient 4.8.1 -> 4.8.2
  • [ALL] dependency update: MySqlConnector 0.69.8 -> 1.0.1
  • [ALL] dependency update: IBM.Data.DB.Provider 11.1.4040.4 -> 11.5.4000.4
  • [LINQPAD5] dependency update: Oracle.ManagedDataAccess.Core 19.8.0 -> 19.9.0
  • [LINQPAD6] bumped target framework netcoreapp3.0 -> netcoreapp3.1
  • [LINQPAD6] dependency update: IBM.Data.DB2.Core 1.3.0.100 -> 3.1.0.300
  • [LINQPAD6] dependency update: Oracle.ManagedDataAccess.Core 2.19.80 -> 2.19.90
  • [LINQPAD6] dependency update: Npgsql 4.1.4 -> 4.1.5
  • [LINQPAD6] dependency update: Microsoft.CodeAnalysis.CSharp 3.6.0 -> 3.7.0
  • [LINQPAD6] dependency update: dotMorten.Microsoft.SqlServer.Types 1.1.0 -> 1.2.0

Release 3.0.1

Release 3.0.0

  • [linqpad] added support for LINQPad 6 including new nuget package (#29)
  • [tools] driver updated to use recent linq2db 3.0.1 release
  • [tools] switched to Humanizer.Core for model pluralization
  • [providers] removed ODP.NET Native Oracle provider (we still support the managed provider, which doesn't require client installation)
  • [providers] added support for MS Access ODBC provider
  • [providers] replaced MySql.Data provider with MySqlConnector provider
  • [providers] replaced native SAP/Sybase ASE provider with managed AdoNetCore.AseClient provider
  • [providers] removed IBM DB2 iSeries support temporarily because required provider lacks linq2db v3 support
  • [providers] added SAP HANA ODBC provider
  • [providers] IBM Informix provider switched to use IBM.Data.DB IDS provider (SQLI provider could be added on request)
  • [providers] there is no need to pre-install client for IBM Informix anymore
  • [providers] there is no need to pre-install client for IBM DB LUW/zOS anymore
  • [providers] there is no need to pre-install client for SAP/Sybase ASE anymore (#33)
  • [providers] fixed multiple issues with provider-specific types support
  • [providers] added support for array and dictionary types (e.g. PostgreSQL array and hstore types)
  • [ui] fixed database tree to not create duplicate/unnecessary schema nodes
  • [ui] fixed connection dialog aligment issues
  • [ui] tables without columns not shown anymore (e.g. Access system tables without read permissions)
  • [ui] added provider path setting for SqlCe and SAP HANA Native providers for LINQPad 6 version
  • [ui] fixed non-xml characters rendering in custom formatter
  • [ui] always use custom formatters for provider-specific types
  • [misc] added license file (MIT) to repository
  • [misc] copyrights updated to include major contributors
  • [misc] migrated to Azure Pipelines from Appveyor for builds
  • [misc] codebase updated to C# 8.0 with nullable reference types