- 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 ConsoleAdd the first Migration
Run the Add-Migration init command in Package Manager ConsoleUpdate Database
Run the Update-Database command in Package Manager ConsoleTo check whether the table named users is created
Run the Projcet and check is there any data have been inserted
转载于:https://www.cnblogs.com/zzy0471/p/demoofusingentityframeworkwithmysql.html