efcore

This is a patch release of EF Core 3.1 containing only updates to dependencies. There are no additional fixes in this release beyond those already shipped in EF Core 3.1.26.

EF Core 7.0 (EF7) preview 5 is available from NuGet

Preview 5 contains the following new features:

• TPC inheritance mapping pattern
• DeleteBehaviorAttribute
• Translate GetType() for entity types with inheritance
• Delay DbCommandInterceptor.CommandCreated until DbCommand properties are initialized
• Remove unnecessary extra batches in SaveChanges
• Don't check for a connection string until after ConnectionOpening has been called
• Add ConnectionCreating/ConnectionCreated to DbConnectionInterceptor
• Migration name filter
• Add support for AT TIME ZONE
• GroupBy aggregate lifting
• Pascal-case the DbContext name when scaffolding

Preview 5 also includes the following new features from previews 1 through 4:

• Support value generation with converters
• Improve batching performance when using TPH mappings
• Attribute (Data Annotations) mapping for composite primary keys
• SQL Server UTF8 collations
• Stop wrapping single changes in transactions where possible
• Use RETURNING/OUTPUT clause for UPDATE/DELETE
• SQLite SaveChanges: Use RETURNING clause
• SQL Server: Optimize SQL Server OUTPUT clause usage when retrieving database-generated values
• Stop automatically deleting orphans for optional relationships with cascade delete configured
• Empty default interface implementations for all interceptor interface methods
• Temporal tables support for owned entities and other table splitting scenarios
• Support for index ordering (ASC/DESC)
• Support "non-rooted" query expressions in compiled queries
• Property/Reference/etc overloads that take IProperty/INavigation
• Distinguish cancellation from failure to allow different logging strategies
• Lift table from subquery when joining if no additional operations
• DiagnosticSuppressor for CS8618 for DbSet properties
• Stop generating a default DbContext constructor when using dotnet ef dbcontext scaffold --no-onconfiguring
• Robust and extensible SQL precedence/parentheses mechanism
• Translation for string.IndexOf(string, int)
• Support SqlNullabilityProcessor and COALESCE with more than two arguments
• Support Contains when using a IReadOnlySet
• Overload of EnableRetryOnFailure that allows specifying errorCodesToAdd without count / delay

See GitHub for all issues resolved in preview 1, preview 2, preview 3, preview 4, and preview 5.

This is a patch release of EF Core 6.0 containing only important bug fixes:

• Can't create a view with navigation property
• Tools: Add dotnet-ef shims arm64
• Diagnostics: DataReaderDisposingEventData.ReadCount accumulates the value from different readers
• Consider setting NullabilityInfoContextSupport=true in EF's NuGet package
• SQLite doesn't work when trimming
• dotnet-ef needs to target 6

Note that this release contains a breaking change for the dotnet-ef command line tool.

This is a patch release of EF Core 3.1 containing only updates to dependencies. There are no additional fixes in this release beyond those already shipped in EF Core 3.1.25.

This is a patch release of EF Core 6.0 containing only important bug fixes:

• Query exception after upgrading from 6.0.1 to 6.0.2

This is a patch release of EF Core 5.0 containing only updates to dependencies. There are no additional fixes in this release beyond those already shipped in EF Core 5.0.16.

This is a patch release of EF Core 3.1 containing only updates to dependencies. There are no additional fixes in this release beyond those already shipped in EF Core 3.1.24.

EF Core 7.0 (EF7) preview 4 is available from NuGet

Preview 4 contains the following new features:

• Support value generation with converters
• Improve batching performance when using TPH mappings

Preview 4 also includes the following new features from previews 1 through 3:

• Attribute (Data Annotations) mapping for composite primary keys
• SQL Server UTF8 collations
• Stop wrapping single changes in transactions where possible
• Use RETURNING/OUTPUT clause for UPDATE/DELETE
• SQLite SaveChanges: Use RETURNING clause
• SQL Server: Optimize SQL Server OUTPUT clause usage when retrieving database-generated values
• Stop automatically deleting orphans for optional relationships with cascade delete configured
• Empty default interface implementations for all interceptor interface methods
• Temporal tables support for owned entities and other table splitting scenarios
• Support for index ordering (ASC/DESC)
• Support "non-rooted" query expressions in compiled queries
• Property/Reference/etc overloads that take IProperty/INavigation
• Distinguish cancellation from failure to allow different logging strategies
• Lift table from subquery when joining if no additional operations
• DiagnosticSuppressor for CS8618 for DbSet properties
• Stop generating a default DbContext constructor when using dotnet ef dbcontext scaffold --no-onconfiguring
• Robust and extensible SQL precedence/parentheses mechanism
• Translation for string.IndexOf(string, int)
• Support SqlNullabilityProcessor and COALESCE with more than two arguments
• Support Contains when using a IReadOnlySet
• Overload of EnableRetryOnFailure that allows specifying errorCodesToAdd without count / delay

See GitHub for all issues resolved in preview 1, preview 2, preview 3, and preview 4.

EF Core 7.0 (EF7) preview 3 is available from NuGet

Previews 1, 2, and 3 do not contain any big new features. However, these previews do contain 38 bug fixes and 46 smaller enhancements, including:

• Attribute (Data Annotations) mapping for composite primary keys
• SQL Server UTF8 collations
• Stop wrapping single changes in transactions where possible
• Use RETURNING/OUTPUT clause for UPDATE/DELETE
• SQLite SaveChanges: Use RETURNING clause
• SQL Server: Optimize SQL Server OUTPUT clause usage when retrieving database-generated values
• Stop automatically deleting orphans for optional relationships with cascade delete configured
• Empty default interface implementations for all interceptor interface methods
• Temporal tables support for owned entities and other table splitting scenarios
• Support for index ordering (ASC/DESC)
• Support "non-rooted" query expressions in compiled queries
• Property/Reference/etc overloads that take IProperty/INavigation
• Distinguish cancellation from failure to allow different logging strategies
• Lift table from subquery when joining if no additional operations
• DiagnosticSuppressor for CS8618 for DbSet properties
• Stop generating a default DbContext constructor when using dotnet ef dbcontext scaffold --no-onconfiguring
• Robust and extensible SQL precedence/parentheses mechanism
• Translation for string.IndexOf(string, int)
• Support SqlNullabilityProcessor and COALESCE with more than two arguments
• Support Contains when using a IReadOnlySet
• Overload of EnableRetryOnFailure that allows specifying errorCodesToAdd without count / delay

See GitHub for all issues resolved in preview 1, preview 2, and preview 3.

This is a patch release of EF Core 6.0 containing only important bug fixes:

• Exception from SQLite provider when application is shutting down
• Collection_navigation_equal_to_null_for_subquery fails after merging from release/6.0
• EF Core 6.0 temporal tables - migration rollback doesn't work
• InvalidOperationException on save after upgrading from 5 to 6

This is a patch release of EF Core 5.0 containing only updates to dependencies. There are no additional fixes in this release beyond those already shipped in EF Core 5.0.15.

This is a patch release of EF Core 3.1 containing only updates to dependencies. There are no additional fixes in this release beyond those already shipped in EF Core 3.1.23.

EF Core 7.0 (EF7) preview 2 is available from NuGet

Previews 1 and 2 do not contain any big new features. However, these previews do contain 30 bug fixes and 33 smaller enhancements, including:

• Temporal tables support for owned entities and other table splitting scenarios
• Support for index ordering (ASC/DESC)
• Support "non-rooted" query expressions in compiled queries
• Property/Reference/etc overloads that take IProperty/INavigation
• Distinguish cancellation from failure to allow different logging strategies
• Lift table from subquery when joining if no additional operations
• DiagnosticSuppressor for CS8618 for DbSet properties
• Stop generating a default DbContext constructor when using dotnet ef dbcontext scaffold --no-onconfiguring
• Robust and extensible SQL precedence/parentheses mechanism
• Translation for string.IndexOf(string, int)
• Support SqlNullabilityProcessor and COALESCE with more than two arguments
• Support Contains when using a IReadOnlySet
• Overload of EnableRetryOnFailure that allows specifying errorCodesToAdd without count / delay

See GitHub for all issues resolved in preview 1 and preview 2.

This is a patch release of EF Core 3.1 containing only updates to dependencies. There are no additional fixes in this release beyond those already shipped in EF Core 3.1.22.

This is a patch release of EF Core 5.0 containing only updates to dependencies. There are no additional fixes in this release beyond those already shipped in EF Core 5.0.14.

This is a patch release of EF Core 6.0 containing only important bug fixes:

• FirstOrDefault after custom projection == null cannot be translated
• DbContext scaffolding creates reference error CS0120 in nameof() for InverseProperty in certain conditions
• EF core 6 selecting null values despite where clause asking for not null
• Query: Rownumber conversion needs better logic to figure out partitions
• Suboptimal SQL generation for query with optional navigation, its collection navigation and lateral join
• Aggregates on multiple child tables produces invalid SQL
• ServiceProviderCache keeps initially created IServiceProvider indefinitely
• Setting a Nullable Foreign Key property to Null triggers cascade delete
• Optimize hangs and stops responding

EF Core 7.0 (EF7) preview 1 is available from NuGet

Preview 1 does not contain any big new features. However, preview 1 does contain 29 bug fixes and 30 smaller enhancements, including:

• Support for index ordering (ASC/DESC)
• Support "non-rooted" query expressions in compiled queries
• Property/Reference/etc overloads that take IProperty/INavigation
• Distinguish cancellation from failure to allow different logging strategies
• Lift table from subquery when joining if no additional operations
• DiagnosticSuppressor for CS8618 for DbSet properties
• Stop generating a default DbContext constructor when using dotnet ef dbcontext scaffold --no-onconfiguring
• Robust and extensible SQL precedence/parentheses mechanism
• Translation for string.IndexOf(string, int)
• Support SqlNullabilityProcessor and COALESCE with more than two arguments
• Support Contains when using a IReadOnlySet
• Overload of EnableRetryOnFailure that allows specifying errorCodesToAdd without count / delay

See GitHub for all issues resolved in preview 1.

This is a patch release of EF Core 5.0 containing only updates to dependencies. There are no additional fixes in this release beyond those already shipped in EF Core 5.0.13.

This is a patch release of EF Core 6.0 containing only important bug fixes:

• Exception when creating new migration after updating from 6.0-rc.1 to 6.0-rc.2 or 6.0-rtm
• efcore6 produces wrong SELECT SQL when Where/OrderBy clauses are applied to Owned properties followed by .Take
• Proxies using Records with a base class broken since .NET 6
• Parentheses put around IS NULL only if operand is of type boolean
• Self-referencing entity circular dependency happening just on EF Core 6.0
• Many To Many Exception when adding and removing same entity
• RelationalConnection.Close calls async function
• Circular dependency while creating tables with DatabaseFacade.EnsureCreated on EF Core 6
• EF Core Migration Bundles: no way to passthrough custom args to generated efbundle
• Did the naming convention change for HasCheckConstraint in v.6? Is this a breaking change?
• Generated JOIN for multiple MIN is wrong
• StackOverflowException in nested GroupBy query
• When trimming, queries fail because of missing System.Math
• GroupBy with outer reference not translating properly, causing data loss
• EF 6.0.0 and 6.0.1: sub-lists are no longer loaded

This is a patch release of EF Core 3.1 containing only updates to dependencies. There are no additional fixes in this release beyond those already shipped in EF Core 3.1.21.