MVC/Code First: how to add more tables to the same db context?

Question

I am using the standard MVC template that comes with VS 2013. It has a neat membership provider that makes using external logins (Google, Facebook etc) a breeze. There are also tutorials on how to extend the IdentityUser model to add new properties such as date of birth.

I would like to add more tables (of my application) to the already coded database context so as to enjoy the same code first migration features. How do I do it? The current db context is defined as follows:

public class ApplicationDbContext : IdentityDbContext<ApplicationUser>
{
    public ApplicationDbContext()
        : base("DefaultConnection", throwIfV1Schema: false)
    {
    }
    public static ApplicationDbContext Create()
    {
        return new ApplicationDbContext();
    }
}

Nazmul Hossain · Accepted Answer · 2015-02-11 07:27:57Z

26

you are using asp.net MVC5 identity 2 then ApplicationDbContext already there in IdentityModels.cs .So you can add table (DbSet) like this.

 public class ApplicationDbContext : IdentityDbContext<ApplicationUser>
{
public ApplicationDbContext()
    : base("ApplicationDbContext", throwIfV1Schema: false)
{
}

public DbSet<Department> Departments { get; set; }
public DbSet<Student> Students { get; set; }

public static ApplicationDbContext Create()
{
    return new ApplicationDbContext();
}
}

answered Feb 11, 2015 at 7:27

Nazmul Hossain

2,0855 gold badges26 silver badges34 bronze badges

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

2 Comments

u936293 Over a year ago

Thanks! It works. My next question: how do I override the Seed method where I can populate some sample rows every time the database is recreated?

Indregaard Over a year ago

Hi, you can do that by implementing a custom database intitializer and overriding the seed method there. have a look here: entityframeworktutorial.net/code-first/…

Collectives™ on Stack Overflow

MVC/Code First: how to add more tables to the same db context?

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