Lerning Entity Framework 6 —— A demo of using Entity framework with MySql

Create a new project named MySqlTest

Install following packages by right-clicking on the References folder of the project and selecting Manage NuGet Packages…

• EntityFramework
• MySql.Data
• MySql.data.Entity

Update the app.config file

Add a model and the DbContext

  public class User
  {
      public int UserId { get; set; }      public string Name { get; set; }
  }  public class MyDb:DbContext
  {
      public MyDb():base("name=TestDb")
      {      }      public DbSet<User> Users { get; set; }
  }

Add some Test Codes

 static void Main(string[] args)
 {
     using (MyDb db = new MyDb())
     {
         User u = new User { Name = "Joey"};
         db.Users.Add(u);
         db.SaveChanges();
     }     Console.ReadLine();
 }

Compile the project

Enable migrations

Run the Enable-Migrations command in Package Manager Console

Add the first Migration

Run the Add-Migration init command in Package Manager Console

Update Database

Run the Update-Database command in Package Manager Console

To check whether the table named users is created

Run the Projcet and check is there any data have been inserted