Entity Framework isn't creating databases

Question

I am trying to create MVC 4 application(OdeToFood tutorial) in VS Express. I have created this class in models.

But when I run the code, Database "OdeToFoodDB2" isn't being created

namespace OdeToFood.Models
{
    public class OdeToFoodDB2 : DbContext
    {
        public DbSet<Resturant> Resturant { get; set; }
        public DbSet<ResturantReview> ResturantReview { get; set; }
    }
}

In web.config file I have following connection string

<add name="DefaultConnection" connectionString="Data Source=(LocalDb)\v11.0;Initial Catalog=aspnet-OdeToFood-20140306003945;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|\aspnet-OdeToFood-20140306003945.mdf" providerName="System.Data.SqlClient" />

but this db doesn't contain the tables that I've specified in Model folder.

Saket Kumar · Accepted Answer · 2014-10-16 05:00:21Z

6

Make your class name same as connection string name. It will work.

<add name="OdeToFoodDB2" connectionString="Data Source=(LocalDb)\v11.0;Initial Catalog=aspnet-OdeToFood-20140306003945;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|\aspnet-OdeToFood-20140306003945.mdf" providerName="System.Data.SqlClient" />

Update:

There are multiple ways in which you can tell the DbContext how to use a database server:

1.) Assuming you have connection string same as above, keep the context class name same as connection string name.

public class OdeToFoodDB2 : DbContext
 {
 }

2.) Alternatively, you can specify the connection string in context base constructor:

public class MyContext : DbContext 
{ 
    public MyContext() 
        : base("OdeToFoodDB2") 
    { 
    } 
}

3.) Alternatively, you can also use the form “name=” for the string passed to the DbContext constructor. For example:

public class MyContext : DbContext 
{ 
    public MyContext() 
        : base("name=OdeToFoodDB2") 
    { 
    } 
}

edited Oct 16, 2014 at 5:00

answered Mar 7, 2014 at 11:26

Saket Kumar

4,8816 gold badges38 silver badges61 bronze badges

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

2 Comments

Saket Kumar Over a year ago

@Awais: U r welcome. Don't forget to vote up. Cheers!

NinjaNye Over a year ago

Nice, didn't realise that +1

NinjaNye · Accepted Answer · 2014-03-07 11:47:46Z

1

DbContext has a constructor overload that takes a connection string name.

You may also want to try adding new initializer to keep the database up to date

namespace OdeToFood.Models
{
    public class OdeToFoodDB2 : DbContext
        : base("DefaultConnection")
    {
        public DbSet<Resturant> Resturant { get; set; }
        public DbSet<ResturantReview> ResturantReview { get; set; }
    }

    protected override void OnModelCreating(DbModelBuilder modelBuilder)
    {
        var initializer = new MigrateDatabaseToLatestVersion<OdeToFoodDB2, Configuration>()
        Database.SetInitializer(initializer);
        base.OnModelCreating();
}

answered Mar 7, 2014 at 11:47

NinjaNye

7,1361 gold badge34 silver badges47 bronze badges

Collectives™ on Stack Overflow

Entity Framework isn't creating databases

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related