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

EF Core 6.0 preview 4 is available from NuGet.

Preview 4 contains the following new features:

• 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

And for Microsoft.Data.Sqlite:

• Add Span overloads to SqliteBlob

Preview 4 also includes the following new features from previews 1, 2, and 3:

• 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

See GitHub for all issues resolved in preview 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.5.

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

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

• EFCore will break on Net6 cause Queryable class will be extended and EF Core Reflection will break

EF Core 6.0 preview 3 is available from NuGet.

Preview 3 contains only small changes over preview 2.

Preview 3 also includes the following new features from previews 1 and 2:

• 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

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

• Default value constraint re-added when using .HasComment()
• EfCore 5 Update method throws "Unable to cast object of type 'System.Int32' to type 'System.Int64'."
• SaveChanges fails for owned entity when owner has PK with default values
• [Regression] ThenInclude back to parent entity isn't working

EF Core 6.0 preview 2 is available from NuGet.

New features in preview 2 include:

• Preserve synchronization context in SaveChangesAsync
• Translate String.Concat with multiple arguments
• Smoother integration with System.Linq.Async
• More flexible free-text search

Preview 2 also includes the following new features from preview 1:

• 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

The .NET Blog announcement has installation instructions and full details.

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

EF Core 6.0 preview 1 is available on NuGet now!

New features in preview 1 include:

• 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

For Microsoft.Data.SQLite 6.0 preview 1:

• Savepoints API
• Command timeout in the connection string

The .NET Blog announcement has installation instructions and full details.

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

Query

• InMemory: Decompose join condition which uses equals for comparison
• IQueryable.All evaluates to false with predicate _ => true
• Loading entity from DB does not properly load owned entities (In memory provider)
• AsSingleQuery can not be translated by in-memory provider
• TryRewriteEntityEquality and NotEqual comparison of CompositePrimaryKey

Migrations

• Builder method mismatch across providers in model snapshot
• MigrationBuilder.InsertData not considering column types passed in
• EF Core generates the same migration even though nothing has changed in the model
• Mangled migration generated when altering database collation

Change tracking

• Adding a join entity instance doesn't populate collections on the participating entities
• Can not build relationships when attach disconnected entities which have many-to-many related entities

Diagnostics

• Issues with event counters

SaveChanges

• Insertion order is wrong when owned entity is involved

Model building

• GetDefaultDatabaseName throws ArgumentNullException for table splitting

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

• Invalid cast from 'System.Int32' to enum in Cosmos queries

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

Change tracking

• Many-to-many lazy (and explicit) loading erroneously sets inverse collection as loaded

Migrations

• Model (seed) data with newlines may result in SQL exceptions
• Migration concatenates strings that are escaped
• SQLite Migrations: Missing table name quotes during rebuild
• Foreign keys for tables marked as ExcludeFromMigrations regenerated in every migrations

Model building

• TPH where derived entities each have Required Owned Entities with Required / Non-Nullable Properties throws SqlException
• Error using case-mismatched mapped properties in many to many relationship
• EntityTypeBuilder: .IsRequired() is ignored if used after .OnDelete()

Query

• Overlapping property in many-to-many join table causes an error

SaveChanges

• EfCore 5 update breaks behavior of RowVersion with Conversions for InMemory database

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

EF Core 5.0.1

• Query
  • Properly generate expression to read provider-specific types from BufferedDataReader
  • Owned collection when owner has composite PK throws translation failure
  • ArgumentOutOfRangeException for split query with owned types
  • Incorrect SQL generated when applying group by over a group by
  • KeyNotFoundException when adding a single projection
  • Incorrect result when doing owner + Include collection + split query + owned type mapped to different table + single
  • InvalidCastException on entities referencing Owned types containing NetTopologySuite Point properties
  • Exception when using inheritance with owned properties in the in-memory database
  • Ternary operator with DateTimes in select gives ArgumentException
  • Object reference not set to an instance of an object exception when using NET Topology Suite in Select projection
  • Provider specific plugin method translator never gets called for indexer property
• Model building
  • Mapping exception with property called FooId on base type Foo in TPT
  • Foreign keys are removed from owned tables when excludedFromMigrations set to true
  • Exception in TPT models with default values
  • Default schema has no effect on views in EF Core 5.0
  • The entity type is part of a relationship cycle involving its primary key
  • StackOverflowException when using same collection navigation twice
  • StackOverflowException with EFCore 5 many-to-many mapping using many-to-one via self
• DbContext
  • Events aren't reset when pooled context is reset asynchronously
• Scaffolding
  • The string argument 'name' cannot be empty when scaffolding a SQLite database
  • System.ArgumentException: The collection argument 'propertyNames' must contain at least one element
  • Collations aren't scaffolded correctly
• SaveChanges
  • SaveChanges fails for SQL Server because of savepoints are not supported when MultipleActiveResultSets is enabled
• Migrations
  • SQL generated for migrations is incorrect when DbContext has TVF mapped using DbFunctionAttribute
  • SQLite Spatial Migrations: Columns with Z and M created incorrectly

Microsoft.Data.Sqlite 5.0.1

• Starting with Microsoft.Data.Sqlite.Core 5.0.0 it is no longer possible to set cipher key options

EF Core 5.0 is available on NuGet now!

• Issues fixed for EF Core 5.0.0

Among the new features for EF Core 5.0 are:

• Many-to-many relationships
• Map entity types to queries
• Event counters
• Property bags
• SaveChanges interception and events
• Exclude tables from migrations
• Required 1:1 dependents
• Options for migration generation
• Migrations scripts with transactions
• See pending migrations
• ModelBuilder API for value comparers
• EntityEntry TryGetValue methods
• Default max batch size for SQL Server
• Default environment to Development
• Better migrations column ordering
• Translation of is on Cosmos
• User-mapped functions can now be annotated to control null propagation
• Support for translation of GroupBy with conditional aggregates
• Translation of Distinct operator over group element before aggregate
• Model building for fields
• Table-per-type (TPT) mapping
• Migrations: Rebuild SQLite tables
• Table-valued functions
• Flexible query/update mapping
• Context-wide split-query configuration
• PhysicalAddress mapping
• Add FieldInfo overload for NavigationBuilder
• Query generation for GroupBy with OwnsOne
• Support join after GroupByAggregate
• Generate a warning for multiple collection Includes
• Convert multiple equality on same column joined by Or/Else into SQL IN expression
• Make discriminator properties read-only be default
• Add an IDbContextFactory that pools context instances
• Cosmos: Allow PK with just the partition key
• Register a factory for DbContext instances in D.I.
• Clear all tracked entities to reset DbContext state
• New pattern for store-generated defaults
• Better support for Cosmos partition keys
• New Cosmos configuration options
• Scaffold-DbContext now singularizes
• Support for database savepoints
• Split queries for Include and projection of collections
• IndexAttribute
• Improved query translation exceptions
• Application-specified transaction IDs
• IPAddress mapping
• Option to exclude OnConfiguring when scaffolding
• Translations for FirstOrDefault, etc. on strings
• Simplification of case blocks in generated SQL
• Database collations
• Flow arguments into IDesignTimeDbContextFactory
• No-tracking queries with identity resolution
• Stored (persisted) computed columns
• SQLite computed columns
• Configure database precision/scale in model
• Specify SQL Server index fill factor
• Filtered Include
• Command-line parameters for namespaces when scaffolding a DbContext or generating migrations
• Command-line support for passing a connection string to [dotnet ef database update]/[Update-Database]
• EnableDetailedErrors provides more information in query mapping exceptions
• Improved support for using Cosmos partition keys in queries
• New ModelBuilder API for navigation properties
• Support for the SQL Server DATALENGTH function
• Use a C# attribute to specify a property backing field
• Complete discriminator mapping
• Performance improvements in Microsoft.Data.Sqlite
• Simple Logging
• Simple way to get generated SQL
• Use a C# attribute to indicate that an entity has no key
• Connection or connection string can be changed on initialized DbContext
• Change-tracking proxies
• Enhanced debug views
• Improved handling of database null semantics
• Indexer properties
• Generation of check constraints for enum mappings
• IsRelational method for differential model building
• Cosmos optimistic concurrency with ETags
• Query translations for more DateTime constructs
• Query translations for more byte array constructs
• Query translation for Reverse
• Query translation for bitwise operators
• Query translation for strings on Cosmos

The .NET Blog announcement has installation instructions and full details.

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

EF Core 5.0 preview RC2 is available on NuGet now!

• Issues fixed for EF Core 5.0.0 but not yet shipped
  • Issues fixed for EF Core 5.0.0 rc2
  • Issues fixed for EF Core 5.0.0 rc1
  • Issues fixed for EF Core 5.0.0 preview 8
  • Issues fixed for EF Core 5.0.0 preview 7
  • Issues fixed for EF Core 5.0.0 preview 6
  • Issues fixed for EF Core 5.0.0 preview 5
  • Issues fixed for EF Core 5.0.0 preview 4
  • Issues fixed for EF Core 5.0.0 preview 3
  • Issues fixed for EF Core 5.0.0 preview 2
  • Issues fixed for EF Core 5.0.0 preview 1

RC2 does not include any new features over those already shipped in RC1. These include:

• Many-to-many relationships
• Map entity types to queries
• Event counters
• Property bags
• SaveChanges interception and events
• Exclude tables from migrations
• Required 1:1 dependents
• Options for migration generation
• Migrations scripts with transactions
• See pending migrations
• ModelBuilder API for value comparers
• EntityEntry TryGetValue methods
• Default max batch size for SQL Server
• Default environment to Development
• Better migrations column ordering
• Translation of is on Cosmos
• User-mapped functions can now be annotated to control null propagation
• Support for translation of GroupBy with conditional aggregates
• Translation of Distinct operator over group element before aggregate
• Model building for fields
• Table-per-type (TPT) mapping
• Migrations: Rebuild SQLite tables
• Table-valued functions
• Flexible query/update mapping
• Context-wide split-query configuration
• PhysicalAddress mapping
• Add FieldInfo overload for NavigationBuilder
• Query generation for GroupBy with OwnsOne
• Support join after GroupByAggregate
• Generate a warning for multiple collection Includes
• Convert multiple equality on same column joined by Or/Else into SQL IN expression
• Make discriminator properties read-only be default
• Add an IDbContextFactory that pools context instances
• Cosmos: Allow PK with just the partition key
• Register a factory for DbContext instances in D.I.
• Clear all tracked entities to reset DbContext state
• New pattern for store-generated defaults
• Better support for Cosmos partition keys
• New Cosmos configuration options
• Scaffold-DbContext now singularizes
• Support for database savepoints
• Split queries for Include and projection of collections
• IndexAttribute
• Improved query translation exceptions
• Application-specified transaction IDs
• IPAddress mapping
• Option to exclude OnConfiguring when scaffolding
• Translations for FirstOrDefault, etc. on strings
• Simplification of case blocks in generated SQL
• Database collations
• Flow arguments into IDesignTimeDbContextFactory
• No-tracking queries with identity resolution
• Stored (persisted) computed columns
• SQLite computed columns
• Configure database precision/scale in model
• Specify SQL Server index fill factor
• Filtered Include
• Command-line parameters for namespaces when scaffolding a DbContext or generating migrations
• Command-line support for passing a connection string to [dotnet ef database update]/[Update-Database]
• EnableDetailedErrors provides more information in query mapping exceptions
• Improved support for using Cosmos partition keys in queries
• New ModelBuilder API for navigation properties
• Support for the SQL Server DATALENGTH function
• Use a C# attribute to specify a property backing field
• Complete discriminator mapping
• Performance improvements in Microsoft.Data.Sqlite
• Simple Logging
• Simple way to get generated SQL
• Use a C# attribute to indicate that an entity has no key
• Connection or connection string can be changed on initialized DbContext
• Change-tracking proxies
• Enhanced debug views
• Improved handling of database null semantics
• Indexer properties
• Generation of check constraints for enum mappings
• IsRelational method for differential model building
• Cosmos optimistic concurrency with ETags
• Query translations for more DateTime constructs
• Query translations for more byte array constructs
• Query translation for Reverse
• Query translation for bitwise operators
• Query translation for strings on Cosmos

The .NET Blog announcement has installation instructions and full details.

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

EF Core 5.0 preview RC1 is available on NuGet now!

New features in RC1 include:

• Many-to-many relationships
• Map entity types to queries
• Event counters
• Property bags
• SaveChanges interception and events
• Exclude tables from migrations
• Required 1:1 dependents
• Options for migration generation
• Migrations scripts with transactions
• See pending migrations
• ModelBuilder API for value comparers
• EntityEntry TryGetValue methods
• Default max batch size for SQL Server
• Default environment to Development
• Better migrations column ordering
• Translation of is on Cosmos
• User-mapped functions can now be annotated to control null propagation
• Support for translation of GroupBy with conditional aggregates
• Translation of Distinct operator over group element before aggregate
• Model building for fields

Remember that all these features from previous previews are also included in RC1:

• Table-per-type (TPT) mapping
• Migrations: Rebuild SQLite tables
• Table-valued functions
• Flexible query/update mapping
• Context-wide split-query configuration
• PhysicalAddress mapping
• Add FieldInfo overload for NavigationBuilder
• Query generation for GroupBy with OwnsOne
• Support join after GroupByAggregate
• Generate a warning for multiple collection Includes
• Convert multiple equality on same column joined by Or/Else into SQL IN expression
• Make discriminator properties read-only be default
• Add an IDbContextFactory that pools context instances
• Cosmos: Allow PK with just the partition key
• Register a factory for DbContext instances in D.I.
• Clear all tracked entities to reset DbContext state
• New pattern for store-generated defaults
• Better support for Cosmos partition keys
• New Cosmos configuration options
• Scaffold-DbContext now singularizes
• Support for database savepoints
• Split queries for Include and projection of collections
• IndexAttribute
• Improved query translation exceptions
• Application-specified transaction IDs
• IPAddress mapping
• Option to exclude OnConfiguring when scaffolding
• Translations for FirstOrDefault, etc. on strings
• Simplification of case blocks in generated SQL
• Database collations
• Flow arguments into IDesignTimeDbContextFactory
• No-tracking queries with identity resolution
• Stored (persisted) computed columns
• SQLite computed columns
• Configure database precision/scale in model
• Specify SQL Server index fill factor
• Filtered Include
• Command-line parameters for namespaces when scaffolding a DbContext or generating migrations
• Command-line support for passing a connection string to [dotnet ef database update]/[Update-Database]
• EnableDetailedErrors provides more information in query mapping exceptions
• Improved support for using Cosmos partition keys in queries
• New ModelBuilder API for navigation properties
• Support for the SQL Server DATALENGTH function
• Use a C# attribute to specify a property backing field
• Complete discriminator mapping
• Performance improvements in Microsoft.Data.Sqlite
• Simple Logging
• Simple way to get generated SQL
• Use a C# attribute to indicate that an entity has no key
• Connection or connection string can be changed on initialized DbContext
• Change-tracking proxies
• Enhanced debug views
• Improved handling of database null semantics
• Indexer properties
• Generation of check constraints for enum mappings
• IsRelational method for differential model building
• Cosmos optimistic concurrency with ETags
• Query translations for more DateTime constructs
• Query translations for more byte array constructs
• Query translation for Reverse
• Query translation for bitwise operators
• Query translation for strings on Cosmos

The .NET Blog announcement has installation instructions and full details.

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