Database initialization failure in asp.net mvc 5

Question

I am trying to create a small test site in mvc. I've created the model as :

  public class Subject_Master
    {
        public Subject_Master()
        {
        }
        public Subject_Master(string Subject_Name)
        {
            this.Subject_Name = Subject_Name;
        }
        public int Subject_MasterId { get; set; }
        public string Subject_Name { get; set; }
    }

Context is :

public class MyContext : DbContext
    {
        public DbSet<StudentAccount> StudentAccount { get; set; }
        public DbSet<Subject_Master> Subject_Master { get; set; }
    }

The initializer :

namespace MyProj.Models
{
    public class DBInitializer:DropCreateDatabaseIfModelChanges<XpertsContext>
    {
        protected override void Seed(XpertsContext context)
        {
            var Subject_Master_List = new List<Subject_Master>();

            Subject_Master_List.Add(new Subject_Master("English"));
            Subject_Master_List.Add(new Subject_Master("Hindi"));
            Subject_Master_List.Add(new Subject_Master("Bengali"));

            foreach (var subject in Subject_Master_List)
            {
                context.Subject_Master.Add(subject);
            }

            context.SaveChanges();
        }
    }
}

The database is created but the data is not getting inserted.

What am I doing wrong ?

Darin Dimitrov · Accepted Answer · 2016-05-08 14:07:40Z

2

You seem to have forgotten to use this DBInitializer class that you wrote. In your Application_Start you could specify the desired initializer using the SetInitializer static method:

Database.SetInitializer(new DBInitializer());

Also don't forget that the initializer's Seed method will be called the first time a query is made against MyContext, not when your application starts.

Alternatively you could specify the initializer in your web.config file as shown here.

answered May 8, 2016 at 14:07

Darin Dimitrov

1.0m276 gold badges3.3k silver badges3k bronze badges

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

2 Comments

Priyabrata Over a year ago

I did that. But now when I ran the project, it didn't insert the data. How ever when I deleted the entire db, and re-ran the project. it got inserted. Is there any way, where, if the db is created already, the data will be inserted without having to delete/re-create db ?

Darin Dimitrov Over a year ago

That's normal, look what class you have derived from: DropCreateDatabaseIfModelChanges. The IfModelChanges part is important. You probably need DropCreateDatabaseAlways if you want your database to be always recreated when the context is first used.

Collectives™ on Stack Overflow

Database initialization failure in asp.net mvc 5

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related