# Release 5.4.2

Changes:

- update dependencies
- [#120](https://github.com/linq2db/linq2db.LINQPad/pull/120): re-enable DB2 iSeries provider support. Thanks to [Marcus Hellsten](https://github.com/mhellsten) for PR

# Release 5.4.1

Update dependencies ([#113](https://github.com/linq2db/linq2db.LINQPad/pull/113), [#114](https://github.com/linq2db/linq2db.LINQPad/issues/114))

# Release 5.2.2

Fix nuget dependencies

# Release 5.2.1

*DELISTED*

Issues fixed:

- [#109](https://github.com/linq2db/linq2db.LINQPad/pull/109): fix dependency issues in 5.2.0 release

# Release 5.2.0

*DELISTED*

Issues fixed:

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

# Release 5.1.0

Issues fixed:

- [#89](https://github.com/linq2db/linq2db.LINQPad/pull/89), [#90](https://github.com/linq2db/linq2db.LINQPad/pull/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](https://github.com/linq2db/linq2db.LINQPad/pull/58): fixed raw SQL execution support for all databases
- [#79](https://github.com/linq2db/linq2db.LINQPad/pull/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](https://github.com/linq2db/linq2db.LINQPad/pull/63) Update Oracle.ManagedDataAccess.Core dependency to fix warning (thanks @db2222)
- [#65](https://github.com/linq2db/linq2db.LINQPad/pull/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](https://github.com/linq2db/linq2db.LINQPad/pull/57) use stable ordering of custom context properties. Thanks to [@RoyChase](https://github.com/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](https://github.com/linq2db/linq2db.LINQPad/issues/47))
- [LINQPAD6] dependency update: FirebirdSql.Data.FirebirdClient 7.10.1 -> 8.0.1
- [LINQPAD6] improve fix for [#39](https://github.com/linq2db/linq2db.LINQPad/issues/39)
- [LINQPAD6] support connection configuration using appsettings.json for typed data context ([#38](https://github.com/linq2db/linq2db.LINQPad/issues/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](https://github.com/linq2db/linq2db.LINQPad/issues/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
- fixed [nuget package](https://www.nuget.org/packages/linq2db.LINQPad) fo LINQPad 6

# Release 3.0.0

- [linqpad] added support for LINQPad 6 including new [nuget package](https://www.nuget.org/packages/linq2db.LINQPad)  ([#29](https://github.com/linq2db/linq2db.LINQPad/issues/29))
- [tools] driver updated to use recent linq2db 3.0.1 release
- [tools] switched to [Humanizer.Core](https://www.nuget.org/packages/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](https://www.nuget.org/packages/MySqlConnector) provider
- [providers] replaced native SAP/Sybase ASE provider with managed [AdoNetCore.AseClient](https://www.nuget.org/packages/AdoNetCore.AseClient) provider
- [providers] removed IBM DB2 iSeries support temporarily because required [provider](https://github.com/LinqToDB4iSeries/Linq2DB4iSeries) lacks linq2db v3 support
- [providers] added SAP HANA ODBC provider
- [providers] IBM Informix provider switched to use [IBM.Data.DB](https://www.nuget.org/packages/IBM.Data.DB2.Core/) 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](https://github.com/linq2db/linq2db.LINQPad/issues/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