Data seeding is a process where you populate the initial set of data into the database. I’ll explain some of the rudimentary steps needed for creating seed data in your app.<\/p>\n
Prior to EF Core 2.1, seeding data was not quite straight-forward. However with this version, you can seed data using the following steps:<\/p>\n
Let’s begin…<\/p>\n
Download Packages:<\/strong> You need the following packages after you create a new .NET Core console app:<\/p>\n Context Class:<\/strong> Create a new context class which would derive from DbContext<\/em>. DbContext<\/em> represents a session with the database and is used to perform CRUD operations against your database. It’s also a combination of Unit of Work and Repository patterns.<\/p>\n Create a Blog class like so:<\/p>\n Be sure to specify the type of database you wish to use. In the example, SQL Server is being used. This is defined in the Context class’s OnConfiguring <\/em>method.<\/p>\n Run Migration:<\/strong> Just a quick overview of Migrations. Migrations allow you to keep your database in sync with your code. EF Core uses your mapping configurations to produce a snapshot of what your database should look like. Your model may represent tables, its primary keys, foreign keys, indexes, constraints and such.<\/p>\n Whenever you make a change to your POCO class i.e. add or remove a property, you ought to run a PowerShell command like so:<\/p>\n Add-Migration <migration name><\/em><\/p>\n The Add-Migration command computes a database schema from your entity classes and scaffolds a migration with Up<\/em> and Down<\/em> methods which consists of the current version of the database to the new version it computes.<\/p>\n Apply Changes to Database:<\/strong> You do this by simply issuing the following command in PowerShell and you are set:<\/p>\n Update-Database<\/em><\/p>\n So, this was a quick intro to seeding data into the database.<\/p>\n","protected":false},"excerpt":{"rendered":" Data seeding is a process where you populate the initial set of data into the database. I’ll explain some of the rudimentary steps needed for creating seed data in your app. Prior to EF Core 2.1, seeding data was not … Continue reading \n
\r\npublic class DataSeedContext : DbContext\r\n {\r\n public DbSet Blog { get; set; }\r\n\r\n protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)\r\n {\r\n optionsBuilder\r\n .UseSqlServer(\r\n @\"server=obi-oberoi; database=demo.DotNetConf; trusted_connection=true;\");\r\n }\r\n protected override void OnModelCreating(ModelBuilder modelBuilder)\r\n {\r\n modelBuilder.Entity()\r\n .Property(u => u.Url)\r\n .IsRequired();\r\n\r\n modelBuilder.Entity().HasData(\r\n new Blog { BlogId = 1, Url = \"http:\/\/ObiOberoi.com\" },\r\n new Blog { BlogId = 2, Url = \"http:\/\/microsoft.com\" },\r\n new Blog { BlogId = 3, Url = \"http:\/\/cnn.com\" },\r\n new Blog { BlogId = 4, Url = \"https:\/\/yahoo.com\"},\r\n new Blog { BlogId = 5, Url = \"https:\/\/tesla.com\" },\r\n new Blog { BlogId = 6, Url = \"https:\/\/meetup.com\/mississauganetug\"},\r\n new Blog { BlogId = 7, Url=\"https:\/\/td.com\"},\r\n new Blog { BlogId = 8, Url=\"https:\/\/meetup.com\/TorontoNETUG\"}\r\n );\r\n }\r\n }\r\n<\/code><\/pre>\n\r\npublic class Blog\r\n {\r\n public int BlogId { get; set; }\r\n [Required]\r\n public string Url { get; set; }\r\n }\r\n<\/code>\r\n<\/pre>\n\r\nprotected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)\r\n {\r\n optionsBuilder\r\n .UseSqlServer(\r\n @\"server=obi-oberoi; database=demo.DotNetConf; trusted_connection=true;\");\r\n }\r\n<\/code><\/pre>\n