Entity Framework Core seed data

Question

So I have a Entity Framework Core first database and a .Net Core application.

I want to add Seed Data to it when creating the database. I know the FluentAPI has the HasData method but that is not what i am looking for.

When the database gets created I want to create a user with a random generated password (that is different every time) that will be saved on a file in the server.

I can't use the HasData method because then it will create the same password everytime.

So my question is: Is there a way, other than the HasData method, to add Seed data to a Entity Framework Core Code First database

TanvirArjel · Accepted Answer · 2018-12-27 13:34:01Z

9

Yes! There is a way! You can do as follows:

public static class DatabaseInitializer
{
    public static void Initialize(YourDbContext dbContext)
    {
        dbContext.Database.EnsureCreated();
        if (!dbContext.Users.Any())
        {
            // Write you necessary to code here to insert the User to database and save the the information to file.

        }

    }
}

The in the Configure method of the Startup class as follows:

public void Configure(IApplicationBuilder app, IHostingEnvironment env, YourDbContext dbContext)
{
   // other configurations
   ..............

   DatabaseInitializer.Initialize(dbContext);

   ..............
   // other configurations
}

Initialize method will be called only once during the application start up.

answered Dec 27, 2018 at 13:34

TanvirArjel

32.4k14 gold badges89 silver badges120 bronze badges

Sign up to request clarification or add additional context in comments.

7 Comments

Imantas Over a year ago

I didn't see ASP.NET Core mentioned anywhere.

Imantas Over a year ago

My point is the question author didn't mention ASP.NET Core anywhere in the question while your code is designed to be used within ASP.NET Core. But probably you guessed it right. Nevermind.

TanvirArjel Over a year ago

Oh! Understood! I have guessed from his question tags! :) Thank you.

kjwdamme Over a year ago

I did mention .Net Core in the question. Thanks for the answer!

Imantas Over a year ago

@kjwdamme .NET Core is not the same as ASP.NET Core.

|

Manoj Choudhari · Accepted Answer · 2018-12-27 14:08:51Z

0

Create a DataSeeder class and Inject DbContext in it. Write a seedData method to insert the required data. This would be custom logic.

You can run this code after database is created.

public class DataSeeder
{
    public static void SeedRandomPassword(YourDbContext context)
    {
            //// your custom logic to generate random password 
            //// set it to right user


            context.Users.Add();  // Or Update depending on what you need
            context.SaveChanges();
        }
    }
}

answered Dec 27, 2018 at 14:08

Manoj Choudhari

5,6742 gold badges28 silver badges38 bronze badges

Collectives™ on Stack Overflow

Entity Framework Core seed data

2 Answers 2

7 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

7 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related