How to create the database when using code first

Question

I'm doing code first approach for the first time, and I created two classes (tables), and a context class.

Context

namespace Idle.Models.Database
{
    public class DatabaseContext : DbContext
    {
        public DatabaseContext() : base("name=Database") 
        {
        }

        public DbSet<Company> Companies{ get; set; }
        public DbSet<Car> Cars{ get; set; }
    }
}

And then I built the project.

But the tables weren't created in my database.

How do I then create my two tables?

Bassam Alugili · Accepted Answer · 2016-06-06 12:21:39Z

1

1) Magic creation, just create your DbContext:

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

using (var databaseContext = new DatabaseContext ())
{
   // Do any stuff here
   databaseContext .SaveChanges();
   Console.WriteLine("Done");
}

2) If you want to use DbMigration: In Nuget console you have to use the command Add-Migration/Update-Migration More info:

https://msdn.microsoft.com/en-us/data/jj591621.aspx

answered Jun 6, 2016 at 12:21

Bassam Alugili

17.1k8 gold badges56 silver badges72 bronze badges

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

Collectives™ on Stack Overflow

How to create the database when using code first

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related