Skip to content

Latest commit

 

History

History
248 lines (205 loc) · 14.6 KB

release-notes.md

File metadata and controls

248 lines (205 loc) · 14.6 KB

Latest version with DB2 iSeries support: 5.4.2

Release 6.0.0-preview.3

Changes:

  • update to linq2db 6.0.0-preview.3
  • update dependencies
  • bump lowest supported .NET runtime version to net8.0 from net6.0
  • supported LinqPad versions for this release are 5 (for .NET Framework) and 8+ (for .NET)
  • added .NET 9 support
  • added support for DB2 provider for LinqPad 5 x64
  • following providers now allow you to select SQL dialect in settings: MySQL/MariaDB, Firebird
  • hide Informix provider from x86 version of LinqPad 8 (there is no x86 driver for .NET available)
  • #125: fix exception thrown for Access database without tables or procedures

DB2 iSeries provider disabled in this version (use 5.4.2 if you need this provider), because it doesn't support Linq To DB 6 yet.

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