linq2db/linq2db v4.2.0

Release 4.2.0

on GitHub

Release highlights:

• ClickHouse database support
• PostgreSQL 15 support (MERGE and InsertOrReplace over MERGE)
• SQL Server 2022 support (IGNORE NULLS qualifiers for FIRST_VALUE/LAST_VALUE window functions, [IS [NOT] DISTINCT FROM operator support)
• BeforeReaderDispose(Async) command interceptor
• Npgsql 7 support, NpgsqlInterval support from Npgsql 6
• TransientRetryPolicy retry policy which use new DbException.IsTransient property (retry policy available only for net6.0+ TFMs)
• support sequence name configuration for columns using fluent mapping
• minor breaking change to type mapping, which could change how System.Convert.ToDecimal/ LinqToDB.Common.Convert converted to SQL for decimal types. See release notes for more details if you use those conversions
• many other fixes and improvements

Scaffold CLI:

• default-schemas option
• [include/exclude]-[stored-procedures/scalar-functions/aggregate-functions] schema filtering options
• fixed ColumnType not provided by schema for table error when scaffolding Access database using ODBC connection
• many other fixes and improvements

Release notes

Nugets

API diff since v4.1.1