Code First Migrations in Entity Framework

Introduction

If you understand Code First Entity Framework then this article is easy to understand the concept of Code First Migration in Entity Framework. If you are unfamiliar with Code First then read this article Code First Entity Framework.

Code First Migration

You have created a database as per the domain requirements and you forgot a column that must exist in the table. You check and the column is not present. You then need not create and delete the existing model to add the new column or table in the database when this approach is used. Code First Migrations allow you to create a new database or update an existing database based on your model classes using the Package Manager Console for running commands.

If you are using the EF code first approach then there are more ways to initialize the database provided by the Entity Framework as follows.

1. DropCreateDatabaseAlways. This database initializer class always drops and creates a new database, whether it is already present or not with every run of the application.
2. DropCreateDatabaseWhenModelChanges. This database initializer class drops the existing database and re-creates it if there is a mismatch between the model classes and table schema.
3. CreateDatabaseIfNotExists.

This class creates a database only if it doesn't exist. It avoids any accidental deletion of the database.

These three databases to be initialized are provided by EF fail when you are updating the model or classes and then it mismatches when it fails and your database records are lost. Here is one solution for this, EF Code First Migration. Using the approach you can change the model class or table or add new classes. Then no database records are lost and your existing database is also the same.

Creating Model and Database

For using this code first migration you need a database and code, first model. Use the procedure for creating the code first model.

1. Open Microsoft Visual Studio.
2. "File" -> "New" -> "Project...".
3. Set the Console Application name as CodeFirstMigration.
4. Click OK.
5. Add the EntityFramework NuGet package.
6. Tools -> Library Package Manager –> Package Manager Console
7. Run the Install-Package EntityFramework command. See the output below:

   

   See the following red color box that shows the added references for EntityFramework and database:

   

8. Add a new class named EmployeeContext.cs to our Entity Framework Code First Context and add the following code. Code for EmployeeContext class file:

   using System;  
   using System.Collections.Generic;  
   using System.Data.Entity;  
   using System.Linq;  
   using System.Text;  
   using System.Threading.Tasks;  
     
   namespace CodeFirstMigration  
   {  
       public class EmployeeContext : DbContext  
       {  
           public DbSet<Employee> Employees { get; set; }  
       }  
     
       public class Employee  
       {  
           public int EmployeeID { get; set; }  
           public string EmpName { get; set; }  
       }  
   }

9. Now we have a model. It's time to do some operation for data access. Add some code to the Program.cs file as in the following: Code for Program class file:

   using System;  
   using System.Collections.Generic;  
   using System.Linq;  
   using System.Text;  
   using System.Threading.Tasks;  
     
   namespace CodeFirstMigration  
   {  
       class Program  
       {  
           static void Main(string[] args)  
           {  
               using (var context = new EmployeeContext())  
               {  
                   //Insert values in database  
                   context.Employees.Add(new Employee { EmployeeID = 1, EmpName = "krishna" });  
                   context.Employees.Add(new Employee { EmployeeID = 2, EmpName = "radha" });  
                   context.SaveChanges();  
     
                   //Get all values from database  
                   foreach (var emp in context.Employees)  
                   {  
                       Console.WriteLine("Employee ID : " + emp.EmployeeID);  
                       Console.WriteLine("Employee Name : " + emp.EmpName);  
                   }  
               }  
     
               Console.WriteLine("Press Any key to exit....");  
               Console.ReadKey();  
           }  
       }  
   }

10. Save the changes and Run. The output is as in the following:

    

11. See in the SQL Server and SQL Server Object Explorer your model CodeFirstMigration.EmployeeContext.