How to set Identity Seed value in code-first?

by

Update 2020.

After EF Core 3.0 now you have a UseIdentityColumn extension method which can be used for setting the seed and increment values for identity columns.

builder.Property(prop => prop.Id)
            .UseIdentityColumn(10000000, 1);

As per offcial documentation:

UseIdentityColumn Configures the key property to use the SQL Server IDENTITY feature to generate values for new entities, when targeting SQL Server. This method sets the property to be OnAdd.

Link

More Related Contents:

  1. Entering keys manually with Entity Framework
  2. Many-to-many self referencing relationship
  3. navigation property should be virtual – not required in ef core?
  4. Can I reuse code for selecting a custom DTO object for a child property with EF Core?
  5. Filter all queries (trying to achieve soft delete)
  6. How to add the same column to all entities in EF Core?
  7. Dynamically changing schema in Entity Framework Core
  8. Include with FromSqlRaw and stored procedure in EF Core 3.1
  9. Could not load file or assembly Microsoft.Extensions.DependencyInjection.Abstractions, Version=1.1.0.0
  10. Entity framework EF.Functions.Like vs string.Contains
  11. The LINQ expression could not be translated and will be evaluated locally
  12. Entity Framework | Sequence contains more than one matching element
  13. Unable to edit db entries using EFCore, EntityState.Modified: “Database operation expected to affect 1 row(s) but actually affected 0 row(s).”
  14. Working with SQL views in Entity Framework Core
  15. EF models. Navigation properties can only participate in a single relationship
  16. Implementing recursive property loading in EF Core
  17. composite key as foreign key
  18. One to one optional relationship using Entity Framework Fluent API
  19. How to compare only Date without Time in DateTime types in Linq to SQL with Entity Framework?
  20. How to generate and auto increment Id with Entity Framework
  21. get date part only from datetime value using entity framework
  22. ASP.NET Identity – Multiple object sets per type are not supported
  23. Entity Framework Code Only error: the model backing the context has changed since the database was created
  24. Update records using LINQ
  25. How should I manage DbContext Lifetime in MVC Core?
  26. C#, entity framework, auto increment
  27. Entity Framework not saving modified children
  28. Change foreign key constraint naming convention
  29. How can set a default value constraint with Entity Framework 6 Code First?
  30. Why Entity Framework performs faster than Dapper in direct select statement [closed]

Leave a Comment