ASP.NET MVC 4 Code first, How add tables using Code first

Question

Im playing currently on visual studio 2012 asp.netmvc4 with simple membership. This will generate 5 tables after running.

My problem is how do i add additional tables? I tried by creating a new model and adding a DbSet on the context class but it will throw error saying dbo.model does not exist in the database. The table is not created.

Is there a standard way of adding a model that will generate a table without running db migrations command?

I even added this Database.SetInitializer(new HWMDContextInitializer()); on application start but the error is still there.

Scrutinizing the code, i figured it out. There is an attribute InitializeSimpleMembershipAttribute, that sets Database.SetInitializer<HWMDContext>(null); so even if there are changes on the model, the database wont be updated. After I added new DropCreateDatabaseIfModelChanges<YourContext>() replacing the null, it already works. — mark vanzuela
– mark vanzuela, Commented Sep 8, 2012 at 14:17

nzic · Accepted Answer · 2012-09-08 11:04:29Z

0

Have you tried this?

protected override void OnStartup(StartupEventArgs e)
    {
        base.OnStartup(e);
        Database.SetInitializer<YourContext>(new DropCreateDatabaseIfModelChanges<YourContext>());

answered Sep 8, 2012 at 11:04

nzic

1849 bronze badges

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

2 Comments

mark vanzuela Over a year ago

added this on application start, Database.SetInitializer<UsersContext>(new DropCreateDatabaseIfModelChanges<UsersContext>()); and i got error: Model compatibility cannot be checked because the database does not contain model metadata. Model compatibility can only be checked for databases created using Code First or Code First Migrations.

lgoncalves Over a year ago

DropCreateDatabaseIfModelChanges needs the EdmMetadata table to check model compatibility. To set up things you might use DropCreateDatabaseAlways or CreateDatabaseIfNotExists initializers instead.

Priyanka · Accepted Answer · 2013-05-22 10:35:13Z

0

Go through this. It will give you the exact approach http://programmaticponderings.wordpress.com/2012/10/30/first-impressions-of-code-first-development-with-entity-framework-5-in-visual-studio-2012/

answered May 22, 2013 at 10:35

Priyanka

3656 silver badges17 bronze badges

Comments

aimme · Accepted Answer · 2015-08-26 20:20:45Z

0

If you want Entity Framework to drop and regenerate your database automatically whenever you change your model schema, use data migrations.

For more information refer to the documentation: http://msdn.microsoft.com/en-us/data/jj591621.aspx

answered Aug 26, 2015 at 20:20

aimme

6,9087 gold badges54 silver badges71 bronze badges

Collectives™ on Stack Overflow

ASP.NET MVC 4 Code first, How add tables using Code first

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related