efcore

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

• DateTime with z suffix is not respected when reading entities
• 'The object has been removed from the model.' when building model
• EF Core 6.0 regression when using HasDefaultSchema() with ToTable(null)
• Variable names must be unique within a query batch or stored procedure
• Stack overflow when using circular composite key dependencies
• SqliteConnectionFactory.cs is not thread-safe
• EF Core 6.0 InvalidOperationException: The object has been removed from the model
• Subquery.Contains throws when the type of item is value type
• Query with n:m relation adds non-existent column
• InvalidOperationException "sequence contains no matching element" in TableReferenceExpression.get_Table
• Update from 5.0.1 to 6.0breaks all SqliteConnection
• Scaffolder throws error if junction table foreign key columns have identical names
• EFCore 6 - NullReferenceException upon EnsureDeleted
• Non-nullable value comparer can't be applied on nullable type
• Exception in SQL server query in EF Core 6, looks related to HasQueryFilter(), worked in EF Core 5
• RC2 Sqlite provider no longer clears temporary files on exit
• The dotnet ef dbcontext scaffold command does not print all expected logs

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.12.

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.20.

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

• ObjectDisposedException on retrieval of a pooled DbContext

EF Core 6.0 GA is now available from NuGet.

See What's New in EF Core 6.0 for a detailed look at all the new features in EF Core 6.0. In summary, the following new features are included in EF Core 6.0:

• Allow defining column order via [ColumnAttribute.Order] when creating tables
• SQL Server temporal tables
• Migrations Bundles
• Cosmos: Add basic support for collections and dictionaries of primitive types
• Cosmos: Add translators for member/methods which map to built-in functions
• Cosmos: Distinct operator in queries
• Cosmos: Diagnostic events including statistics (query cost, activity id)
• Cosmos: API to configure throughput
• Cosmos: Configure TTL per entity/entity type/container
• Cosmos: FromSql support
• Cosmos: Resolve HttpClientFactory from DI if available
• Cosmos: Azure Cosmos DB provider should default to implicit ownership
• Detect simple join tables in reverse engineering and create many-to-many relationships
• Translate GroupBy followed by FirstOrDefault over group
• Support ability to select top N of each group
• Remove unnecessary last column in ORDER BY when joining for collection
• Add IColumnModification and IModificationCommand to allow the implementations to be replaced easily
• Non-constant property name in EF.Property (and indexer property)
• Make the non-thread-safety of DbContext more visible
• Store options in ServiceProviderCache
• Adopt MIT license
• Warn when uniquifying an FK column name
• Preserve DeleteBehavior when scaffolding a database created by EF Core
• Add overloads of UsingEntity() that take advantage of conventions
• Log provider version in addition to EF Core version
• Indicate where SQL comes from (SaveChanges, LINQ query, etc.) in IDbCommandInterceptor
• Register a scoped DbContext automatically when using AddDbContextFactory
• Add extension methods to enable simpler adding and configuration of EF Core providers
• Simplify HasConversion API
• Support Timeout.InfiniteTimeSpan in SetCommandTimeout
• Support suspending/bypassing the configured DbContext's IExecutionStrategy
• Support 64-bit Identity seed values
• Warn when saving an optional dependent with all null properties when table splitting
• Remove existing schema when HasSchema(null) is called
• Add equivalent of IRelationalDbContextOptionsBuilderInfrastructure to in-memory provider
• Make HasDbFunction on function override implicit ToTable mapping
• Make IScaffoldingModelFactory public
• Uniquify and validate Check Constraint name
• Translate MathF members to SQL functions on SQLite
• Pre-convention model configuration
• Mechanism/API to specify a default conversion for any property of a given type in the model
• Support Ignore() for non entity type candidates
• Reduce EF Core application startup time via compiled models
• Add TagWith overload that gets the filename and line number automatically
• Translate bool ToString for SQL Server
• Scaffold from a database and generate C# 8 nullable reference types
• Translate Substring with single parameter
• Support split queries for projections containing non-navigation collections
• Improve EF Core performance on TechEmpower Fortunes
• Support empty constructor and DbContextOptions constructor in DbContextFactory
• Make DbContext pooling accessible to non-DI applications
• Increase the default maximum context pool size to 1024
• Improvements to optional dependents sharing table with principal
• Detection of trailing underscores when matching backing fields to properties
• Performance gain by recycling relational and ADO.NET objects in query execution
• Allow explicit temporary values to be stored in entity instances
• Default options added to all ToDebugString methods
• Improved logging of array parameter values
• Preserve synchronization context in SaveChangesAsync
• Translate String.Concat with multiple arguments
• Smoother integration with System.Linq.Async
• More flexible free-text search
• UnicodeAttribute
• PrecisionAttribute
• EntityTypeConfigurationAttribute
• Translate ToString on SQLite
• EF.Functions.Random
• Support for SQL Server sparse columns
• In-memory database: validate required properties are not null
• Improved SQL Server translation for IsNullOrWhitespace
• Database comments are scaffolded to code comments

And for Microsoft.Data.Sqlite:

• Support the new BCL DateOnly and TimeOnly structs for SQLite
• Fall back to case-insensitive matches for SqliteDataReader[<string>]
• Add Span overloads to SqliteBlob
• Pool Connections

See GitHub for all issues fixed in EF Core 6.0 and the Git release tag.

This is a patch release of EF Core 3.1 containing only important bug fixes.

• Update SQLitePCLRaw.bundle_e_sqlite3 from 2.0.2 to 2.0.4

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.10.

EF Core 6.0 RC2 is available from NuGet. The RC2 release contains all the features planned for EF Core 6.0.

Consider using the daily builds to get fixes made for GA since the RC2 release was built.

See What's New in EF Core 6.0 for a detailed look at all the new features in EF Core 6.0. In summary, the following new features are included in EF Core 6.0:

• Allow defining column order via [ColumnAttribute.Order] when creating tables
• SQL Server temporal tables
• Migrations Bundles
• Cosmos: Add basic support for collections and dictionaries of primitive types
• Cosmos: Add translators for member/methods which map to built-in functions
• Cosmos: Distinct operator in queries
• Cosmos: Diagnostic events including statistics (query cost, activity id)
• Cosmos: API to configure throughput
• Cosmos: Configure TTL per entity/entity type/container
• Cosmos: FromSql support
• Cosmos: Resolve HttpClientFactory from DI if available
• Cosmos: Azure Cosmos DB provider should default to implicit ownership
• Detect simple join tables in reverse engineering and create many-to-many relationships
• Translate GroupBy followed by FirstOrDefault over group
• Support ability to select top N of each group
• Remove unnecessary last column in ORDER BY when joining for collection
• Add IColumnModification and IModificationCommand to allow the implementations to be replaced easily
• Non-constant property name in EF.Property (and indexer property)
• Make the non-thread-safety of DbContext more visible
• Store options in ServiceProviderCache
• Adopt MIT license
• Warn when uniquifying an FK column name
• Preserve DeleteBehavior when scaffolding a database created by EF Core
• Add overloads of UsingEntity() that take advantage of conventions
• Log provider version in addition to EF Core version
• Indicate where SQL comes from (SaveChanges, LINQ query, etc.) in IDbCommandInterceptor
• Register a scoped DbContext automatically when using AddDbContextFactory
• Add extension methods to enable simpler adding and configuration of EF Core providers
• Simplify HasConversion API
• Support Timeout.InfiniteTimeSpan in SetCommandTimeout
• Support suspending/bypassing the configured DbContext's IExecutionStrategy
• Support 64-bit Identity seed values
• Warn when saving an optional dependent with all null properties when table splitting
• Remove existing schema when HasSchema(null) is called
• Add equivalent of IRelationalDbContextOptionsBuilderInfrastructure to in-memory provider
• Make HasDbFunction on function override implicit ToTable mapping
• Make IScaffoldingModelFactory public
• Uniquify and validate Check Constraint name
• Translate MathF members to SQL functions on SQLite
• Pre-convention model configuration
• Mechanism/API to specify a default conversion for any property of a given type in the model
• Support Ignore() for non entity type candidates
• Reduce EF Core application startup time via compiled models
• Add TagWith overload that gets the filename and line number automatically
• Translate bool ToString for SQL Server
• Scaffold from a database and generate C# 8 nullable reference types
• Translate Substring with single parameter
• Support split queries for projections containing non-navigation collections
• Improve EF Core performance on TechEmpower Fortunes
• Support empty constructor and DbContextOptions constructor in DbContextFactory
• Make DbContext pooling accessible to non-DI applications
• Increase the default maximum context pool size to 1024
• Improvements to optional dependents sharing table with principal
• Detection of trailing underscores when matching backing fields to properties
• Performance gain by recycling relational and ADO.NET objects in query execution
• Allow explicit temporary values to be stored in entity instances
• Default options added to all ToDebugString methods
• Improved logging of array parameter values
• Preserve synchronization context in SaveChangesAsync
• Translate String.Concat with multiple arguments
• Smoother integration with System.Linq.Async
• More flexible free-text search
• UnicodeAttribute
• PrecisionAttribute
• EntityTypeConfigurationAttribute
• Translate ToString on SQLite
• EF.Functions.Random
• Support for SQL Server sparse columns
• In-memory database: validate required properties are not null
• Improved SQL Server translation for IsNullOrWhitespace
• Database comments are scaffolded to code comments

And for Microsoft.Data.Sqlite:

• Support the new BCL DateOnly and TimeOnly structs for SQLite
• Fall back to case-insensitive matches for SqliteDataReader[<string>]
• Add Span overloads to SqliteBlob
• Pool Connections

See GitHub for all issues resolved in RC2.

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.18.

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.9.

EF Core 6.0 RC1 is available from NuGet.

The RC1 release contains all the features planned for EF Core 6.0, except Allow defining column order via [ColumnAttribute.Order] when creating tables which will ship in RC2.

See What's New in EF Core 6.0 for a detailed look at all the new features in EF Core 6.0.

RC1 contains the following new features over those previously shipped in Preview 7:

• SQL Server temporal tables
• Migrations Bundles
• Cosmos: Add basic support for collections and dictionaries of primitive types
• Cosmos: Add translators for member/methods which map to built-in functions
• Cosmos: Distinct operator in queries
• Cosmos: Diagnostic events including statistics (query cost, activity id)
• Cosmos: API to configure throughput
• Cosmos: Configure TTL per entity/entity type/container
• Cosmos: FromSql support
• Cosmos: Resolve HttpClientFactory from DI if available
• Cosmos: Azure Cosmos DB provider should default to implicit ownership
• Detect simple join tables in reverse engineering and create many-to-many relationships
• Translate GroupBy followed by FirstOrDefault over group
• Support ability to select top N of each group
• Remove unnecessary last column in ORDER BY when joining for collection
• Add IColumnModification and IModificationCommand to allow the implementations to be replaced easily
• Non-constant property name in EF.Property (and indexer property)
• Make the non-thread-safety of DbContext more visible
• Store options in ServiceProviderCache
• Adopt MIT license
• Warn when uniquifying an FK column name
• Preserve DeleteBehavior when scaffolding a database created by EF Core
• Add overloads of UsingEntity() that take advantage of conventions
• Log provider version in addition to EF Core version
• Indicate where SQL comes from (SaveChanges, LINQ query, etc.) in IDbCommandInterceptor
• Register a scoped DbContext automatically when using AddDbContextFactory
• Add extension methods to enable simpler adding and configuration of EF Core providers
• Simplify HasConversion API

And for Microsoft.Data.Sqlite:

• Pool Connections

RC1 also includes the following new features in previews 1 through 7:

• Support Timeout.InfiniteTimeSpan in SetCommandTimeout
• Support suspending/bypassing the configured DbContext's IExecutionStrategy
• Support 64-bit Identity seed values
• Warn when saving an optional dependent with all null properties when table splitting
• Remove existing schema when HasSchema(null) is called
• Add equivalent of IRelationalDbContextOptionsBuilderInfrastructure to in-memory provider
• Make HasDbFunction on function override implicit ToTable mapping
• Make IScaffoldingModelFactory public
• Uniquify and validate Check Constraint name
• Translate MathF members to SQL functions on SQLite
• Pre-convention model configuration
• Mechanism/API to specify a default conversion for any property of a given type in the model
• Support Ignore() for non entity type candidates
• Reduce EF Core application startup time via compiled models
• Add TagWith overload that gets the filename and line number automatically
• Translate bool ToString for SQL Server
• Scaffold from a database and generate C# 8 nullable reference types
• Translate Substring with single parameter
• Support split queries for projections containing non-navigation collections
• Improve EF Core performance on TechEmpower Fortunes
• Support empty constructor and DbContextOptions constructor in DbContextFactory
• Make DbContext pooling accessible to non-DI applications
• Increase the default maximum context pool size to 1024
• Improvements to optional dependents sharing table with principal
• Detection of trailing underscores when matching backing fields to properties
• Performance gain by recycling relational and ADO.NET objects in query execution
• Allow explicit temporary values to be stored in entity instances
• Default options added to all ToDebugString methods
• Improved logging of array parameter values
• Preserve synchronization context in SaveChangesAsync
• Translate String.Concat with multiple arguments
• Smoother integration with System.Linq.Async
• More flexible free-text search
• UnicodeAttribute
• PrecisionAttribute
• EntityTypeConfigurationAttribute
• Translate ToString on SQLite
• EF.Functions.Random
• Support for SQL Server sparse columns
• In-memory database: validate required properties are not null
• Improved SQL Server translation for IsNullOrWhitespace
• Database comments are scaffolded to code comments

And for Microsoft.Data.Sqlite:

• Support the new BCL DateOnly and TimeOnly structs for SQLite
• Fall back to case-insensitive matches for SqliteDataReader[<string>]
• Add Span overloads to SqliteBlob

See GitHub for all issues resolved in RC1.

This is a patch release of EF Core 5.0 containing only important bug fixes.

• Port fix for "Code generation for custom data annotation attributes is broken"
• HasDbFunction to an otherwise unmapped entity causes strange migration behavior

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.17

EF Core 6.0 preview 7 is available from NuGet

Preview 7 contains the first cut of Migration Bundles. Preview 7 also includes the following features from previews 1 through 6:

• Support Timeout.InfiniteTimeSpan in SetCommandTimeout
• Support suspending/bypassing the configured DbContext's IExecutionStrategy
• Support 64-bit Identity seed values
• Warn when saving an optional dependent with all null properties when table splitting
• Remove existing schema when HasSchema(null) is called
• Add equivalent of IRelationalDbContextOptionsBuilderInfrastructure to in-memory provider
• Make HasDbFunction on function override implicit ToTable mapping
• Make IScaffoldingModelFactory public
• Uniquify and validate Check Constraint name
• Translate MathF members to SQL functions on SQLite
• Pre-convention model configuration
• Mechanism/API to specify a default conversion for any property of a given type in the model
• Support Ignore() for non entity type candidates
• Reduce EF Core application startup time via compiled models
• Add TagWith overload that gets the filename and line number automatically
• Translate bool ToString for SQL Server
• Scaffold from a database and generate C# 8 nullable reference types
• Translate Substring with single parameter
• Support split queries for projections containing non-navigation collections
• Improve EF Core performance on TechEmpower Fortunes
• Support empty constructor and DbContextOptions constructor in DbContextFactory
• Make DbContext pooling accessible to non-DI applications
• Increase the default maximum context pool size to 1024
• Improvements to optional dependents sharing table with principal
• Detection of trailing underscores when matching backing fields to properties
• Performance gain by recycling relational and ADO.NET objects in query execution
• Allow explicit temporary values to be stored in entity instances
• Default options added to all ToDebugString methods
• Improved logging of array parameter values
• Preserve synchronization context in SaveChangesAsync
• Translate String.Concat with multiple arguments
• Smoother integration with System.Linq.Async
• More flexible free-text search
• UnicodeAttribute
• PrecisionAttribute
• EntityTypeConfigurationAttribute
• Translate ToString on SQLite
• EF.Functions.Random
• Support for SQL Server sparse columns
• In-memory database: validate required properties are not null
• Improved SQL Server translation for IsNullOrWhitespace
• Database comments are scaffolded to code comments

And for Microsoft.Data.Sqlite:

• Support the new BCL DateOnly and TimeOnly structs for SQLite
• Fall back to case-insensitive matches for SqliteDataReader[<string>]
• Add Span overloads to SqliteBlob

See GitHub for all issues resolved in preview 6.

This is a patch release of EF Core 3.1 containing only critical bug fixes.

• Output #nullable disable in reverse-engineered model
• Specify CultureInfo in Controller make query not working

EF Core 6.0 preview 6 is available from NuGet.

Preview 6 contains the following new features:

• Support Timeout.InfiniteTimeSpan in SetCommandTimeout
• Support suspending/bypassing the configured DbContext's IExecutionStrategy
• Support 64-bit Identity seed values
• Warn when saving an optional dependent with all null properties when table splitting
• Remove existing schema when HasSchema(null) is called
• Add equivalent of IRelationalDbContextOptionsBuilderInfrastructure to in-memory provider
• Make HasDbFunction on function override implicit ToTable mapping
• Make IScaffoldingModelFactory public
• Uniquify and validate Check Constraint name
• Translate MathF members to SQL functions on SQLite
• Pre-convention model configuration
• Mechanism/API to specify a default conversion for any property of a given type in the model
• Support Ignore() for non entity type candidates

And for Microsoft.Data.Sqlite:

• Support the new BCL DateOnly and TimeOnly structs for SQLite

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

• Reduce EF Core application startup time via compiled models
• Add TagWith overload that gets the filename and line number automatically
• Translate bool ToString for SQL Server
• Scaffold from a database and generate C# 8 nullable reference types
• Translate Substring with single parameter
• Support split queries for projections containing non-navigation collections
• Improve EF Core performance on TechEmpower Fortunes
• Support empty constructor and DbContextOptions constructor in DbContextFactory
• Make DbContext pooling accessible to non-DI applications
• Increase the default maximum context pool size to 1024
• Improvements to optional dependents sharing table with principal
• Detection of trailing underscores when matching backing fields to properties
• Performance gain by recycling relational and ADO.NET objects in query execution
• Allow explicit temporary values to be stored in entity instances
• Default options added to all ToDebugString methods
• Improved logging of array parameter values
• Preserve synchronization context in SaveChangesAsync
• Translate String.Concat with multiple arguments
• Smoother integration with System.Linq.Async
• More flexible free-text search
• UnicodeAttribute
• PrecisionAttribute
• EntityTypeConfigurationAttribute
• Translate ToString on SQLite
• EF.Functions.Random
• Support for SQL Server sparse columns
• In-memory database: validate required properties are not null
• Improved SQL Server translation for IsNullOrWhitespace
• Database comments are scaffolded to code comments

And for Microsoft.Data.Sqlite:

• Fall back to case-insensitive matches for SqliteDataReader[<string>]
• Add Span overloads to SqliteBlob

See GitHub for all issues resolved in preview 6.

This is a patch release of EF Core 5.0 containing only important bug fixes.

• Using Concat for model/seed data in migrations may truncate long strings

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.16.

EF Core 6.0 preview 5 is available from NuGet.

Preview 5 contains the following new features:

• Reduce EF Core application startup time via compiled models
• Add TagWith overload that gets the filename and line number automatically
• Translate bool ToString for SQL Server
• Scaffold from a database and generate C# 8 nullable reference types
• Translate Substring with single parameter
• Support split queries for projections containing non-navigation collections
• Improve EF Core performance on TechEmpower Fortunes
• Support empty constructor and DbContextOptions constructor in DbContextFactory
• Make DbContext pooling accessible to non-DI applications
• Increase the default maximum context pool size to 1024

And for Microsoft.Data.Sqlite:

• Fall back to case-insensitive matches for SqliteDataReader[<string>]

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

• Improvements to optional dependents sharing table with principal
• Detection of trailing underscores when matching backing fields to properties
• Performance gain by recycling relational and ADO.NET objects in query execution
• Allow explicit temporary values to be stored in entity instances
• Default options added to all ToDebugString methods
• Improved logging of array parameter values
• Preserve synchronization context in SaveChangesAsync
• Translate String.Concat with multiple arguments
• Smoother integration with System.Linq.Async
• More flexible free-text search
• UnicodeAttribute
• PrecisionAttribute
• EntityTypeConfigurationAttribute
• Translate ToString on SQLite
• EF.Functions.Random
• Support for SQL Server sparse columns
• In-memory database: validate required properties are not null
• Improved SQL Server translation for IsNullOrWhitespace
• Database comments are scaffolded to code comments

And for Microsoft.Data.Sqlite:

• Add Span overloads to SqliteBlob

See GitHub for all issues resolved in preview 5.

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.6.