EF 5 Code First Migration Bulk SQL Data Seeding

ef-code-first, entity-framework, entity-framework-migrations

Solution

Here is how you can seed bulk data by just providing the .sql files in seed method.

public class AppContextInitializer : CreateDatabaseIfNotExists<AppContext>
{
    protected override void Seed(AppContext context)
    {
        var sqlFiles = Directory.GetFiles(AppDomain.CurrentDomain.BaseDirectory, "*.sql").OrderBy(x => x);
        foreach (string file in sqlFiles)
        {
            context.Database.ExecuteSqlCommand(File.ReadAllText(file));
        }

        base.Seed(context);
    }
}

Problem

I am using EF5 with MVC4. The problem is that I have large data in my DB which I already imported from legacy DB. I want to load seed that data when model changes. My question is how can I seed large amount of data that is already in my DB? ``` internal sealed class Configuration : MigrationsConfiguration<VoiceLab.Models.EFDataContext> { public Configuration() { AutomaticMigrationsEnabled = true; } protected override void Seed(VoiceLab.Models.EFDataContext context) { //what to do here to seed thousands or records that are already in db } } ``` thanks,

Original source