Code First Migration Using NuGet Commands In ASP.NET MVC 5

In code first approach, classes are defined by the means of C# or VB code with properties, these classes will be generated into tables and properties are converted into columns by Entity Framework when executing code.

In this article we will implement code first migration approach using NuGet Commands.

Step By Step Walkthrough

Step 1

Go to Visual Studio 2013 and ASP.NET Web Application

Step 2

Add MVC Application

Add ConnectionString Web.Config File where you wish to create table.

Step 3

Now add a model class which you wanted to be created in the database.

Step 4

Here we named our class as UserInfo.

Step 5

Add another class file in model for creating table in the database.

Step 7

Declare attributes which you wanted as column in table.

Step 8

Now the time is to give the connectionstring and name of the table on second class file i.e, UserContext. Before you do this you have to add using System.Data.Entity to inherit UserContext class with DbContext as in the following figure:

DBContext

Step 9

After this step, build the solution.

Step 10

Now go to Tools, NuGet Package Manager, then Packet Manager Console

Run the following NuGet Commands.

This command basically creates Migration folder in the solution consisting of configuration class file.

Configuration file

In this file we can configure migrations of context.

Add-Migration and provide migration name

This command will bring the mentioned database to update and can check SQL for running migration.

Whole NuGet Command execution in Packet Manager Console is given in the following code snippet: