CODEWITHSUNDEEP
c#asp.net-mvcentity-frameworkvisual-studio
abalter
abalter

Reputation: 10393

Why are code-first tables not being created using Entity framework?

Yet another in the saga of the ASP MVC tutorial I'm working through. Everything was going along pretty nicely, except, I noticed that two of the three tables being created had no data in them. Unable to figure out why, I got serious and deleted the database thinking I would let it be created again from scratch. Well, now the database is created, but has no tables in it. AND, data that would be in a table is still getting passed to the view. I'm very confused.

SchoolContext.cs

public class SchoolContext : DbContext
{
    public DbSet<Student> Students { get; set; }
    public DbSet<Course> Courses { get; set; }
    public DbSet<Enrollment> Enrollments { get; set; }
....
....

SchoolInitializer.cs

public class SchoolInitializer : DropCreateDatabaseIfModelChanges<SchoolContext>
{
    protected override void Seed(SchoolContext context)
    {
        var students = new List<Student>()
        {
            new Student{FirstName = "James", LastName = "Dean", EnrollmentDate = DateTime.Parse("01/01/2015")},
            new Student{FirstName = "Linda", LastName = "Thames", EnrollmentDate = DateTime.Parse("01/01/2015")}
        };

        foreach (var student in students)
        {
            context.Students.Add(student);  
        }
        context.SaveChanges();

...And a Courses table and an Enrollment table...

XyzController.cs

public class XyzController : Controller
{
    private SchoolContext db = new SchoolContext();
    // GET: Xyz
    public ActionResult Abc()
    {
        var students = db.Students.ToList();

Student data is passed to view

But no tables in the DB

Upvotes: 4

Views: 3482

Answers (1)

Aram
Aram

Reputation: 5705

Do you have your Database Initializer setup correctly? You will need something like this:

Database.SetInitializer(new DropCreateDatabaseAlways<BlogContext>());

You should put this line in the Application_Start() method in Global.asax If yes, you can recycle your app pool to make this code to run again.

Upvotes: 1

Related Questions