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 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