Changes in IDENTITY column after EF core 3

by

This behavior was expected in 3.0?

Yes, it is one of the 3.0 Breaking Changes – Temporary key values are no longer set onto entity instances.

The proposed solutions there are:

  • Not using store-generated keys.
  • Setting navigation properties to form relationships instead of setting foreign key values.
  • Obtain the actual temporary key values from the entity’s tracking information. For example, context.Entry(blog).Property(e => e.Id).CurrentValue will return the temporary value even though blog.Id itself hasn’t been set.

Option #1 doesn’t make sense (apparently the affected places already use store generated keys).

Option #2 is preferable if you have navigation properties.

Option #3 is closer to the previous behavior, but requires access to the db context.

More Related Contents:

  1. Equivalent for .HasOptional in Entity Framework Core 1 (EF7)
  2. Loop/reflect through all properties in all EF Models to set Column Type
  3. EntityFramework Core automatic migrations
  4. Using EF Core ThenInclude() on Junction tables
  5. What goes into DbContextOptions when invoking a new DbContext?
  6. EF Core Second level ThenInclude missworks
  7. No executable found matching command “dotnet-ef”
  8. How to select top N rows for each group in a Entity Framework GroupBy with EF 3.1
  9. Entity framework core update many to many
  10. Dynamically changing schema in Entity Framework Core
  11. ef core 2 apply HasQueryFilter for all entity
  12. Unable to edit db entries using EFCore, EntityState.Modified: “Database operation expected to affect 1 row(s) but actually affected 0 row(s).”
  13. Implementing recursive property loading in EF Core
  14. Entity Framework Core 2.0 – Run migrations step by step
  15. EF Core 2: How to apply HasQueryFilter for all entities
  16. ASP.NET MVC 2.0 Implementation of searching in jqgrid
  17. Code First: Independent associations vs. Foreign key associations?
  18. Unique Key constraints for multiple columns in Entity Framework
  19. Database first create entity framework 6.1.1 model using system.data.sqlite 1.0.93
  20. “like” queries in Entity Framework
  21. Could not load file or assembly Microsoft.Extensions.DependencyInjection.Abstractions, Version=1.1.0.0
  22. MetadataException when using Entity Framework Entity Connection [duplicate]
  23. Avoid or control circular references in Entity Framework Core
  24. How to use Entity Framework to map results of a stored procedure to entity with differently named parameters
  25. Nullable property to entity field, Entity Framework through Code First
  26. Entity Framework Code First Using Guid as Identity with another Identity Column
  27. AutomaticMigrationsEnabled false or true?
  28. How to get user information in DbContext using Net Core
  29. ADO.NET Entity Framework tutorials [closed]
  30. Compose queries across Entity Data Models

Leave a Comment