linq2db

Release Highlights

• minor bugfix release

Release notes

Nugets

API diff since v5.4.0

New Contributors

• @alexey-leonovich made their first contribution in https://github.com/linq2db/linq2db/pull/4443
• @AndreyShipunov made their first contribution in https://github.com/linq2db/linq2db/pull/4459

Full Changelog: https://github.com/linq2db/linq2db/compare/v5.4.0...v5.4.1

Release highlights:

• add library metrics collection API
• add support for one-way conversions in MappingSchema to specify logic for DB <-> application values conversion in one direction only
• ensure library works with object <-> string conversions using Invariant culture everywhere
• add support for ClickHouse.Client 6.8.0+ provider versions
• many small improvements and bug-fixes

Release notes

Nugets

API diff since v5.3.2

This release fixes regression in Npgsql 7- support from previous release

Release notes

Nugets

API diff since v5.3.1

This release adds support for Npgsql 8.0.0 (rc-2)

Release notes

Nugets

API diff since v5.3.0

Release highlights

• implement fixes to avoid data context instance caching in query cache
• improvements to collection-typed parameter values logging
• fixed null support for value IN (subquery) expressions
• fixes several issues with NativeAOT builds
• retract obsoletion note from T4 scaffold nugets
• many other fixes and improvements

Release notes

Nugets

API diff since v5.2.2

Bugfix release

Release notes

Nugets

API diff since v5.2.1

Release highlights:

• fix regression in new properties handling
• other bugfixes

Release notes

Nugets

API diff since v5.2.0

Release highlights:

• multiple fixes/improvements to interface-based mappings
• fixes to DataContext use in eager load and in multi-db environments
• MySQL/MariaDB: INSERT .. SELECT query hints supports (e.g. FOR UPDATE)
• ClickHouse: initial support for query hints: FINAL, SETINGS, join modifiers
• Firebird: fix query from parameter-less stored procedures
• other bugfixes and small improvements

Release notes

Nugets

API diff since v5.1.1

Fix Connection string is not provided error in some setups

Release notes

Nugets

API diff since v5.1.0

Release highlights:

• SQL Server temporal table queries filtering support
• WhereKeyOptimistic query filter helper to add filter using entity's primary key and optimistic lock field value
• Support for fluent mappings generation (or no mappings at all) on database scaffold using linq2db.cli tool
• many other improvements and fixes

Release notes

Nugets

API diff since v5.0.0

Changes since RC.2:

• IMetadataReader simplification
• bugfixes

Release notes

Nugets

API diff since v5.0.0-rc.2

• fixed order of columns in query for mappings with inheritance
• other fixes and improvements

Release notes

Nugets

API diff since v5.0.0-rc.1

• add source columns support in MergeWithOutput* APIs
• downgrade Microsoft.Extensions.DependencyInjection and Microsoft.Extensions.Logging.Abstractions dependencies to v6 LTS for linq2db.AspNet package
• bugfixes

Also due to compatibility issues from Oracle we don't support use of MySql.Data provider with MariaDB databases anymore. Just another good reason to switch to modern MySqlConnector provider from legacy MySql.Data.

Release notes

Nugets

API diff since v5.0.0-preview.2

Second and last preview for new Linq To DB version

• new API for optimistic lock delete and update operations
• support for C# nullable reference types annotations in mapping for columns and single-record associations
• FOR UPDATE/SHARE hints helpers for MySQL and MariaDB
• A lot of performance improvements
• Breaking changes to fluent mapping configuration
• Breaking changes to context mapping schema edit and System.Data.Linq.Mapping / System.ComponentModel.DataAnnotations.Schema mappings support
• Breaking changes to IMetadataReader interface signatures and behavior
• new UseBeforeConnectionOpened and UseAfterConnectionOpened context configuration extensions to simplify custom connection configuration for users
• many other improvements and bugfixes

Release notes

Nugets

API diff since v5.0.0-preview.1

Minor bugfixing release

Release notes

Nugets

API diff since v4.4.0

Release highlights:

• major configuration refactoring
• removal of obsoleted APIs

Release notes

Nugets

API diff since v4.4.0

Release highlights:

• InsertWithOutput API support for IValueInsertable-based syntax (.Value(...))
• apply nullability to non-nullable columns from left joins
• fix issue where InsertWithOutput wasn't working for columns with column name != property name
• use stable ordering of members/types in code generated by scaffolder
• fixed incorrect mappings generated by scaffolder for composite keys
• add net6/7 support to scaffold tool
• SQL Server temporal tables scaffold support
• transaction disposal logic changed to use Dispose instead of Rollback to avoid errors when transaction was already closed by untracked code (e.g. using raw SQL)
• fixed issue with some mapping attributes cannot be added using fluent mapping since 4.0 release
• many other improvements and bugfixes

Release notes

Nugets

API diff since v4.3.0

Release highlights:

• string.TrimEnd(string value, char[] chars)\string.TrimStart(string value, char[] chars) mapping improvements (chars parameter support)
• bug fixes

Release notes

Nugets

API diff since v4.2.0

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

Release highlights:

• bugfixes/improvements

Release notes

Nugets

API diff since v4.1.0