efcore

EF Core 6.0.21 is available on NuGet now. This is a patch release of EF Core 6 containing only important bug fixes:

• Silent data loss when adding objects to an sqlite DB with PRAGMA journal_mode=DELETE in a multi-threaded environment.

EF Core 7.0.10 is available on NuGet now. This is a patch release of EF Core 7 containing only important bug fixes:

• Scaffolding synapse fails when attempting to enumerate triggers
• Silent data loss when adding objects to an sqlite DB with PRAGMA journal_mode=DELETE in a multi-threaded environment.

EF Core 8 (EF8) Preview 7 is available from NuGet

Preview 6 contains the following new features:

• Optimized translation for indexing of JSON primitive collections
• Translate DateOnly.FromDateTime
• Implement JSON serialization/deserialization via Utf8JsonReader/Utf8JsonWriter
• How to do a missing migration check in CI
• Update pattern for scaffolding column default constraints

In addition, Preview 2 contains the following features from Previews 1, 2, 3, 4, 5, and 6:

• Analyzer: warn (and code fix) for use of interpolation in SQL methods accepting raw strings
• Translate Contains to IN with subquery instead of EXISTS where relevant
• Support arbitrary expressions in inline collections (translate to VALUES)
• Allow inline primitive collections with parameters, translating to VALUES
• SQLite RevEng: Sample data to determine CLR type
• Allow default value check in value generation to be customized
• Update handling of non-nullable store-generated properties
• IN() list queries are not parameterized, causing increased SQL Server CPU usage
• Allow 'unsharing' connection between contexts
• Remove unneeded subquery and projection when using ordering without limit/offset in set operations
• Make SequentialGuidValueGenerator non-allocating
• Support querying over primitive collections
• JSON/Sqlite: use -> and ->> where possible when traversing JSON, rather than json_extract
• Add Generic version of EntityTypeConfiguration Attribute
• NativeAOT/trimming compatibility for Microsoft.Data.Sqlite
• Map collections of primitive types to JSON column in relational database
• Translate DateTimeOffset.ToUnixTime(Seconds|Milliseconds)
• Allow pooling DbContext with singleton services
• Optional RestartSequenceOperation.StartValue
• Generate compiled relational model
• Global query filters produce too many parameters
• Optimize update path for single property JSON element
• JSON columns can be used in compiled models
• Unneeded parentheses removed in SQL queries
• Set operations are supported over non-entity projections with different facets
• Json: add support for Sqlite provider
• SQL Server: Support hierarchyid
• Configuration to opt out of occasionally problematic SaveChanges optimizations
• Add convention types for triggers
• Translate element access of a JSON array
• Raw SQL queries for unmapped types
• Support the new BCL DateOnly and TimeOnly structs for SQL Server
• Translate ElementAt(OrDefault)
• Opt-out of lazy-loading for specific navigations
• Lazy-loading for no-tracking queries
• Reverse engineer Synapse and Dynamics 365 TDS
• Set MaxLength on TPH discriminator property by convention
• Translate ToString() on a string column
• Generic overload of ConventionSetBuilder.Remove
• Lookup tracked entities by primary key, alternate key, or foreign key
• Allow UseSequence and HiLo on non-key properties
• Pass query tracking behavior to materialization interceptor
• Use case-insensitive string key comparisons on SQL Server
• Allow value converters to change the DbType
• Resolve application services in EF services
• Numeric rowersion properties automatically convert to binary
• Allow transfer of ownership of DbConnection from application to DbContext
• Provide more information when 'No DbContext was found' error is generated

See GitHub for all issues resolved in Preview 1, Preview 2, Preview 3, Preview 4, Preview 5, Preview 6, and Preview 7.

EF Core 8 (EF8) Preview 6 is available from NuGet

Preview 6 contains the following new features:

• Analyzer: warn (and code fix) for use of interpolation in SQL methods accepting raw strings
• Translate Contains to IN with subquery instead of EXISTS where relevant
• Support arbitrary expressions in inline collections (translate to VALUES)
• Allow inline primitive collections with parameters, translating to VALUES

In addition, Preview 2 contains the following features from Previews 1, 2, 3, 4, and 5:

• SQLite RevEng: Sample data to determine CLR type
• Allow default value check in value generation to be customized
• Update handling of non-nullable store-generated properties
• IN() list queries are not parameterized, causing increased SQL Server CPU usage
• Allow 'unsharing' connection between contexts
• Remove unneeded subquery and projection when using ordering without limit/offset in set operations
• Make SequentialGuidValueGenerator non-allocating
• Support querying over primitive collections
• JSON/Sqlite: use -> and ->> where possible when traversing JSON, rather than json_extract
• Add Generic version of EntityTypeConfiguration Attribute
• NativeAOT/trimming compatibility for Microsoft.Data.Sqlite
• Map collections of primitive types to JSON column in relational database
• Translate DateTimeOffset.ToUnixTime(Seconds|Milliseconds)
• Allow pooling DbContext with singleton services
• Optional RestartSequenceOperation.StartValue
• Generate compiled relational model
• Global query filters produce too many parameters
• Optimize update path for single property JSON element
• JSON columns can be used in compiled models
• Unneeded parentheses removed in SQL queries
• Set operations are supported over non-entity projections with different facets
• Json: add support for Sqlite provider
• SQL Server: Support hierarchyid
• Configuration to opt out of occasionally problematic SaveChanges optimizations
• Add convention types for triggers
• Translate element access of a JSON array
• Raw SQL queries for unmapped types
• Support the new BCL DateOnly and TimeOnly structs for SQL Server
• Translate ElementAt(OrDefault)
• Opt-out of lazy-loading for specific navigations
• Lazy-loading for no-tracking queries
• Reverse engineer Synapse and Dynamics 365 TDS
• Set MaxLength on TPH discriminator property by convention
• Translate ToString() on a string column
• Generic overload of ConventionSetBuilder.Remove
• Lookup tracked entities by primary key, alternate key, or foreign key
• Allow UseSequence and HiLo on non-key properties
• Pass query tracking behavior to materialization interceptor
• Use case-insensitive string key comparisons on SQL Server
• Allow value converters to change the DbType
• Resolve application services in EF services
• Numeric rowersion properties automatically convert to binary
• Allow transfer of ownership of DbConnection from application to DbContext
• Provide more information when 'No DbContext was found' error is generated

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

EF Core 7.0.9 is available on NuGet now. This is a patch release of EF Core 7 containing only important bug fixes:

• Error "Index was outside the bounds of the array." when reading from dataset without AsNoTracking()

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

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

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

EF Core 8 (EF8) Preview 5 is available from NuGet

Preview 5 contains the following new features:

• SQLite RevEng: Sample data to determine CLR type
• Allow default value check in value generation to be customized
• Update handling of non-nullable store-generated properties

In addition, Preview 2 contains the following features from Previews 1, 2, 3, and 4:

• IN() list queries are not parameterized, causing increased SQL Server CPU usage
• Allow 'unsharing' connection between contexts
• Remove unneeded subquery and projection when using ordering without limit/offset in set operations
• Make SequentialGuidValueGenerator non-allocating
• Support querying over primitive collections
• JSON/Sqlite: use -> and ->> where possible when traversing JSON, rather than json_extract
• Add Generic version of EntityTypeConfiguration Attribute
• NativeAOT/trimming compatibility for Microsoft.Data.Sqlite
• Map collections of primitive types to JSON column in relational database
• Translate DateTimeOffset.ToUnixTime(Seconds|Milliseconds)
• Allow pooling DbContext with singleton services
• Optional RestartSequenceOperation.StartValue
• Generate compiled relational model
• Global query filters produce too many parameters
• Optimize update path for single property JSON element
• JSON columns can be used in compiled models
• Unneeded parentheses removed in SQL queries
• Set operations are supported over non-entity projections with different facets
• Json: add support for Sqlite provider
• SQL Server: Support hierarchyid
• Configuration to opt out of occasionally problematic SaveChanges optimizations
• Add convention types for triggers
• Translate element access of a JSON array
• Raw SQL queries for unmapped types
• Support the new BCL DateOnly and TimeOnly structs for SQL Server
• Translate ElementAt(OrDefault)
• Opt-out of lazy-loading for specific navigations
• Lazy-loading for no-tracking queries
• Reverse engineer Synapse and Dynamics 365 TDS
• Set MaxLength on TPH discriminator property by convention
• Translate ToString() on a string column
• Generic overload of ConventionSetBuilder.Remove
• Lookup tracked entities by primary key, alternate key, or foreign key
• Allow UseSequence and HiLo on non-key properties
• Pass query tracking behavior to materialization interceptor
• Use case-insensitive string key comparisons on SQL Server
• Allow value converters to change the DbType
• Resolve application services in EF services
• Numeric rowersion properties automatically convert to binary
• Allow transfer of ownership of DbConnection from application to DbContext
• Provide more information when 'No DbContext was found' error is generated

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

EF Core 7.0.7 is available on NuGet now. This is a patch release of EF Core 7 containing only important bug fixes:

• IndexOutOfRangeException in CreateNavigationExpansionExpression
• Linq select cannot project an entity containing both Json columns and ICollections
• Json: updating property with conversion from string to other type fails on sql server
• Duplicate table alias in generated select query (An item with the same key has already been added)
• InvalidOperationException when calling ExecuteUpdate with owned entity & using current value
• Query/Json: projecting entity collection along with json collection generates invalid shaper
• AutoInclude causes ExecuteDelete to fail
• Multiple LeftJoins (GroupJoins) lead to GroupJoin Exception when the same where is used twice
• SaveChanges circular dependency in unique unfiltered index (when change doesn't affect any column from unique index).

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

EF Core 8 (EF8) Preview 4 is available from NuGet

Preview 4 contains the following new features:

• IN() list queries are not parameterized, causing increased SQL Server CPU usage
• Allow 'unsharing' connection between contexts
• Remove unneeded subquery and projection when using ordering without limit/offset in set operations
• Make SequentialGuidValueGenerator non-allocating
• Support querying over primitive collections
• JSON/Sqlite: use -> and ->> where possible when traversing JSON, rather than json_extract
• Add Generic version of EntityTypeConfiguration Attribute
• NativeAOT/trimming compatibility for Microsoft.Data.Sqlite
• Map collections of primitive types to JSON column in relational database
• Translate DateTimeOffset.ToUnixTime(Seconds|Milliseconds)
• Allow pooling DbContext with singleton services
• Optional RestartSequenceOperation.StartValue
• Generate compiled relational model
• Global query filters produce too many parameters

In addition, Preview 2 contains the following features from Previews 1, 2, and 3:

• Optimize update path for single property JSON element
• JSON columns can be used in compiled models
• Unneeded parentheses removed in SQL queries
• Set operations are supported over non-entity projections with different facets
• Json: add support for Sqlite provider
• SQL Server: Support hierarchyid
• Configuration to opt out of occasionally problematic SaveChanges optimizations
• Add convention types for triggers
• Translate element access of a JSON array
• Raw SQL queries for unmapped types
• Support the new BCL DateOnly and TimeOnly structs for SQL Server
• Translate ElementAt(OrDefault)
• Opt-out of lazy-loading for specific navigations
• Lazy-loading for no-tracking queries
• Reverse engineer Synapse and Dynamics 365 TDS
• Set MaxLength on TPH discriminator property by convention
• Translate ToString() on a string column
• Generic overload of ConventionSetBuilder.Remove
• Lookup tracked entities by primary key, alternate key, or foreign key
• Allow UseSequence and HiLo on non-key properties
• Pass query tracking behavior to materialization interceptor
• Use case-insensitive string key comparisons on SQL Server
• Allow value converters to change the DbType
• Resolve application services in EF services
• Numeric rowersion properties automatically convert to binary
• Allow transfer of ownership of DbConnection from application to DbContext
• Provide more information when 'No DbContext was found' error is generated

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

EF Core 7.0.5 is available on NuGet now. This is a patch release of EF Core 7 containing only important bug fixes:

• Can't add migration renaming a column on TPC root
• Scaffolded collection navigation properties do not have setters
• EF7 generating incorrect SQL for the Concat/Union All
• Added nullable property to Json mapped model resulting in errors instead of mapping non existing json property to null

EF Core 8 (EF8) Preview 3 is available from NuGet

Preview 3 contains the following new features:

• Optimize update path for single property JSON element
• JSON columns can be used in compiled models
• Unneeded parentheses removed in SQL queries
• Set operations are supported over non-entity projections with different facets

In addition, Preview 2 contains the following features from Previews 1 and 2:

• Json: add support for Sqlite provider
• SQL Server: Support hierarchyid
• Configuration to opt out of occasionally problematic SaveChanges optimizations
• Add convention types for triggers
• Translate element access of a JSON array
• Raw SQL queries for unmapped types
• Support the new BCL DateOnly and TimeOnly structs for SQL Server
• Translate ElementAt(OrDefault)
• Opt-out of lazy-loading for specific navigations
• Lazy-loading for no-tracking queries
• Reverse engineer Synapse and Dynamics 365 TDS
• Set MaxLength on TPH discriminator property by convention
• Translate ToString() on a string column
• Generic overload of ConventionSetBuilder.Remove
• Lookup tracked entities by primary key, alternate key, or foreign key
• Allow UseSequence and HiLo on non-key properties
• Pass query tracking behavior to materialization interceptor
• Use case-insensitive string key comparisons on SQL Server
• Allow value converters to change the DbType
• Resolve application services in EF services
• Numeric rowersion properties automatically convert to binary
• Allow transfer of ownership of DbConnection from application to DbContext
• Provide more information when 'No DbContext was found' error is generated

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 updates to dependencies. There are no additional fixes in this release beyond those already shipped in EF Core 6.1.15.

EF Core 8 (EF8) Preview 2 is available from NuGet

Preview 2 contains the following new features:

• Json: add support for Sqlite provider
• SQL Server: Support hierarchyid
• Configuration to opt out of occasionally problematic SaveChanges optimizations
• Add convention types for triggers

In addition, Preview 2 contains the following features from Preview 1:

• Translate element access of a JSON array
• Raw SQL queries for unmapped types
• Support the new BCL DateOnly and TimeOnly structs for SQL Server
• Translate ElementAt(OrDefault)
• Opt-out of lazy-loading for specific navigations
• Lazy-loading for no-tracking queries
• Reverse engineer Synapse and Dynamics 365 TDS
• Set MaxLength on TPH discriminator property by convention
• Translate ToString() on a string column
• Generic overload of ConventionSetBuilder.Remove
• Lookup tracked entities by primary key, alternate key, or foreign key
• Allow UseSequence and HiLo on non-key properties
• Pass query tracking behavior to materialization interceptor
• Use case-insensitive string key comparisons on SQL Server
• Allow value converters to change the DbType
• Resolve application services in EF services
• Numeric rowersion properties automatically convert to binary
• Allow transfer of ownership of DbConnection from application to DbContext
• Provide more information when 'No DbContext was found' error is generated

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

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

• Exception replacing multi-level relationship in EF7
• Deletion can cause error "The association between entity types A and B has been severed..."
• Non-empty second migration in TPC scheme using inheritance
• Entity Framework Core 7 keeps creating the same migration for Nullable DateTime field
• TPC mapping strategy not respecting default database schema during migration
• Count after Take throws "No column name was specified for column 1 of 't'."

And for Microsoft.Data.Sqlite:

• ArgumentOutOfRangeException in SqliteConnectionFactory.PruneCallback

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

EF Core 8 (EF8) preview 1 is available from NuGet

Preview 1 contains the following new features:

• Translate element access of a JSON array
• Raw SQL queries for unmapped types
• Support the new BCL DateOnly and TimeOnly structs for SQL Server
• Translate ElementAt(OrDefault)
• Opt-out of lazy-loading for specific navigations
• Lazy-loading for no-tracking queries
• Reverse engineer Synapse and Dynamics 365 TDS
• Set MaxLength on TPH discriminator property by convention
• Translate ToString() on a string column
• Generic overload of ConventionSetBuilder.Remove
• Lookup tracked entities by primary key, alternate key, or foreign key
• Allow UseSequence and HiLo on non-key properties
• Pass query tracking behavior to materialization interceptor
• Use case-insensitive string key comparisons on SQL Server
• Allow value converters to change the DbType
• Resolve application services in EF services
• Numeric rowersion properties automatically convert to binary
• Allow transfer of ownership of DbConnection from application to DbContext
• Provide more information when 'No DbContext was found' error is generated

See GitHub for all issues resolved in preview 1.

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

• Add-Migration fails with "An item with the same key has already been added" when renaming entity
• ExecuteUpdate fails when target entity has an owned entity
• EF Core 7 Rev eng: Missing HasForeignKey when referencing a navigation property with a unique constraint with DataAnnotations on
• Change in behaviour of CSharpHelper.Identifier(string name)
• NullReferenceException scaffolding when no primary key set
• Idempotent migration script not working on EFCore7.0 for AlterColumn when nullable changed from true to false
• 6.0.11 to 7.0.0: [...] are both mapped to column [..] but are configured to use differing provider types ('double' and 'double?').'
• Generated Model Snapshot throws InvalidOperationException
• SQL Server bulk insert broken when new command applies pending commands and goes over the batch parameter limit
• Invalid singularization when scaffolding a manytomany table
• In EF7, SqLite unable to load spatialite using the NetTopologySuite Package
• Cannot access property through interface in ExecuteUpdate setter lambda
• DbContext scaffold missing IndexerProperty for M2M relation after moving to EF Core 7
• Performance regression in model building in Entity Framework Core 7
• Mixing sproc and non-sproc commands in the same batch may fail with a NullReferenceException
• Condition's order will cause different result when using .Contains() to search string cross varchar and nvarchar columns
• SaveChanges circular dependency in unique unfiltered index
• QueryTrackingBehavior resets to TrackAll when using DbContext pooling
• EFCore 7.0.0 - Graph of entity insertion throws a FK exception
• Replacing PK to PK TPH dependent with different type fails
• dotnet ef migrations add freezes
• InvalidOperationException when mapping properties of different types to the same column
• Obsoletion message for AutoTransactionsEnabled is wrong
• Incorrect NullReferenceException for parameter in split query with GroupBy