How to seed in Entity Framework Core 2?

by

As of Entity Framework Core 2.1 there is now a new method of seeding data. In your DbContext class override OnModelCreating:

protected override void OnModelCreating(ModelBuilder modelBuilder)
{
    modelBuilder.Entity<Blog>().HasData(new Blog { BlogId = 1, Url = "http://sample.com" });
}

And for related entities, use anonymous classes and specify the foreign key of the related entity:

modelBuilder.Entity<Post>().HasData(
    new {BlogId = 1, PostId = 1, Title = "First post", Content = "Test 1"},
    new {BlogId = 1, PostId = 2, Title = "Second post", Content = "Test 2"});

Important: Please note you will need to run an add-migration after you enter this data in your OnModelCreating method and Update-Database to update your data.

The official docs have been updated.

More Related Contents:

  1. How to instantiate a DbContext in EF Core
  2. auto create database in Entity Framework Core
  3. Filter all queries (trying to achieve soft delete)
  4. How to add the same column to all entities in EF Core?
  5. Command dotnet ef not found
  6. How to unapply a migration in ASP.NET Core with EF Core
  7. Cascade deleting with EF Core
  8. Could not load file or assembly Microsoft.Extensions.DependencyInjection.Abstractions, Version=1.1.0.0
  9. How to auto create database on first run?
  10. Entity framework EF.Functions.Like vs string.Contains
  11. EF Core queries all columns in SQL when mapping to object in Select
  12. How to refresh an Entity Framework Core DBContext?
  13. Entity Framework Core: `SqlNullValueException: Data is Null.` How to troubleshoot?
  14. ef core doesn’t use ASPNETCORE_ENVIRONMENT during update-database
  15. How to get user information in DbContext using Net Core
  16. How should I manage DbContext Lifetime in MVC Core?
  17. How to resolve .net core build error NETDSDK1061 and warning MSB3277
  18. Get the serial number of USB storage devices in .Net Core 2.1
  19. System.Text.Json: How do I specify a custom name for an enum value?
  20. How to validate signature of JWT from jwks without x5c
  21. Include with FromSqlRaw and stored procedure in EF Core 3.1
  22. Publish .NET Core App As Portable Executable
  23. Entity Framework Core: Guid Greater Than for Paging
  24. Unit testing with EF Core and in memory database
  25. EF models. Navigation properties can only participate in a single relationship
  26. Using a Scoped service in a Singleton in an Asp.Net Core app
  27. .Net Core – copy to clipboard?
  28. Conditional dependency resolver on run-time (.net Core)
  29. Entity Framework Core RC2 table name pluralization
  30. Export private/public keys from X509 certificate to PEM

Leave a Comment