Home » Ado.Net » Entity Framework » Entity Framework Database Setup for Code First

Entity Framework Database Setup for Code First

This article is part of a series of Entity Framework articles. This first article is how to generate the database from mode classes.

First, let’s define model classes that will be used across all articles.

public class Person
{
    public int Id { get; set; }
    public int Name { get; set; }
    public DateTime BirthDate { get; set; }

    public ICollection<Person> Friends { get; set; }

    public House Residence { set; get; }
}

public class House
{
    public int Id { get; set; }
    public double Price { get; set; }

    public Address Address { get; set; }

    public ICollection<Person> Resident { get; set; }
    public Person Owner { get; set; }
}

public class Address
{
    public string Street { get; set; }
    public int Number { get; set; }
    public string City { get; set; }
}

But, first we will comment the Address class and all references to it. The reason is that we do not want for the moment to configure anything.

Then, we need to add Entity Framework to your project.

EntityFrameworkAddNugetReference

The last step is to tell Entity Framework to initialize the database. This will create the database and all tables defined by the DbContext.

public static void BuildDatabase()
{
    using (var context = new YourContext())
    {
        context.Database.Initialize(true);
    }
}

We could also add an Entity to the database to generate the database automatically. This would produce the same result.

public static void BuildByAddingEntity()
{
    using (var context = new YourContext())
    {
        var stud = new Person() { Name = "Person1", BirthDate = new DateTime(1990, 01, 01) };
        context.Persons.Add(stud);
        context.SaveChanges(); 
    }
}

The result is not very interesting because it creates something without the help of any connection string. This mean that the database name is generated with the context name and the namespace. For example, the code executed generate a database would be “EntityFrameworkTestConsole.DataAccessLayer.YourContext”. To fix this issue, we need to define a connection string and than set it in the YourContext. It also has used the default Sql Server defined for your machine. In general, it is SQL Express. This is very restrictive.

SqlManagerEntityFrameworkDatabaseName

If you setup a connection string with a name, for example you could use “DefaultConnection”, this one will be used if set in the context.

The app.config is where the connection string can be defined.

  <configSections>
    <!-- For more information on Entity Framework configuration, visit http://go.microsoft.com/fwlink/?LinkID=237468 -->
    <section name="entityFramework" 
             type="System.Data.Entity.Internal.ConfigFile.EntityFrameworkSection, EntityFramework, Version=6.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" 
             requirePermission="false" />
  </configSections>
  <connectionStrings>
    <add name="DefaultConnection" 
         connectionString="Data Source=(LocalDb)\v11.0;Initial Catalog=EntityFrameworkTestConsole;Integrated Security=True" 
         providerName="System.Data.SqlClient" />
  </connectionStrings>
public class YourContext : DbContext
{
    public YourContext(): base("DefaultConnection")
    {

    }
    public DbSet<Person> Persons { get; set; }
    public DbSet<House> Houses { get; set; }
}

This generate the database with the name specified in the Catalog from the connection string. You could also specify directly the connection string into the base() but this will be a show stopper if you are building application that must change the server and database depending of the environment (dev, test, prod).

SqlManagerEntityFrameworkDatabaseName2

Entity Framework takes care of everything for you. Tables are created from your entity defined in your context. It also takes care of all primary keys and foreign keys for you.
DatabaseTables

So far, we have see that Entity Framework can generate the database from minimalist code. Only a context need to be defined. Of course, setting a connection string and associate the connection string name with the context give you more control to which server and database to connect Entity Framework.

You can find this code at GitHub. This version of code can be downloaded in a Zip file here.

If you like my article, think to buy my annual book, professionally edited by a proofreader. directly from me or on Amazon. I also wrote a TypeScript book called Holistic TypeScript

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.