.Net and MOSS News

You heard about Entity Framework and want to try it. Let’s start with a very simple example. We will create a Console Application, add a class Person and generate the database from this class.
Open Visual Studio and create a Console Application. I called mine EFFirstSample.
Now, you have to allow Code First on your project. To do that, add Entity Framework from NuGet package. Open Visual Studio, go to Tools -> Library Package Manager -> Manage NuGet Packages and select EntityFrameworkpackage. It will add all references to your project.

Add package

Once added, check references in your project. EntityFramework should have appeared. You should also see a new file package.config. This file contains all information about NuGet packages installed.

Ok, so now, we can start our project. We will first add a new class file : Person.cs and declare four properties : an ID, a lastname, a firstname and a date of birth, like this :

public class Person
{
    public int PersonId { get; set; }
    public string LastName { get; set; }
    public string FirstName { get; set; }
    public DateTime BirthDate { get; set; }
}

Now, we will create a class to manage the link with the database : our DBContext. Add a new class MyContext.cs and let it inherite from DbContext class (add System.Data.Entity as using)

using System.Data.Entity;

namespace EFFirstSample
{
    public class MyContext : DbContext
    {
        public MyContext()
        {}
    }
}

So now, we will tell to the context what should be created in the database. Add the following line :

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

It allow the context to know that it will contains a collection of Persons (and that a table Person should be created).
If we run the application, nothing will happen. You can check, connecting to your SqlExpress instance.
Let’s add some code in our Console, to call our context. Go to Program class and modify it like that :

static void Main(string[] args)
{
    var person = new Person {FirstName = "Nadege", LastName = "Deroussen", BirthDate = DateTime.Now};
    using (var context = new MyContext())
    {
        context.Persons.Add(person);
        context.SaveChanges();
    }
    Console.Write("Person saved !");
    Console.ReadLine();
}

We just create a new Person and add it to the database. Now, run the application and check the message before closing.

Save a person

It’s time to check in the person was well created. Connect to SqlExpress and check that a new database was created.

On the Toolbar Server Explorer, you should be a Data Connections node. If the toolbar is not visible, go to View -> Server Explorer

Right click on the node and select Add connection. A new window appears. Add your server (.\SqlExpress if you use SQL Express) and select your database in the dropdownlist. Here is what I have :

Test your connection and validate with the OK button. You should now see your database.

You can see a People table and an EdmMetadata table. The first one represent the table corresponding to your Person class. Why is it name People ? Because of naming convention. EF Code First uses pluralization rules and so our DbSet Persons is rename “People”, singularized.
Right click on the table name and select Open table definition. You should see something like that :

You can see the PersonId has been created as a primary key. How is it possible ? We don’t specify anything !
It’s simple. Code First uses naming convention to determine which property should be used as primary key. If you name a property TableNameId, Code First will see that this property will be used to define the primary key. Very simple.
There is other way to define the property that would match the primary key. We will see that in a future post.

The other table, EdmMetadata, stores a hash that will allow EF to check if there is modification to the model or not.

You just create your first, simple, application with Entity Framework Code First.
In a future post, we will see how to add multiple table with foreign key.

Edit (Jan, 27th 2012) : Add information on how to connect to the database