.NetCore中EFCore for MySql

柔光的暖阳◎ 2022-05-26 11:24 244阅读 0赞

1、新建.NetCore项目

添加依赖项

Microsoft.EntityFrameworkCore.Tools

MySql.Data.EntityFrameworkCore

![这里写图片描述][70]

2、然后新建一个DbContext类。

public class DBContext:DbContext
        {
            public DBContext(DbContextOptions<DBContext> options)
                : base(options)
            {
            }
    
            public DbSet<student> student { get; set; }
            //这里也可以
            //string str = @"Data Source=;Database=;User ID=;Password=;pooling=true;CharSet=utf8;port=3306;sslmode=none";
            //protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder) =>
            // optionsBuilder.UseMySQL(str);
    
        }

3、创建数据库映射  
`注意：大小写和数据库保持一致`

public class student
        {
            public int id { get; set; }
            public string name { get; set; }
            public int age { get; set; }
        }

4、appsettings.json里添加连接字符串

{
      "Logging": { "IncludeScopes": false, "LogLevel": { "Default": "Warning" } },
      "ConnectionStrings": { "MysqlConnection": "Data Source=localhost;Database=test;User ID=root;Password=123456;pooling=true;CharSet=utf8;port=3306;sslmode=none" } }

5、在Startup.cs文件的ConfigureServices方法添加

public void ConfigureServices(IServiceCollection services)
            {
                //注意：一定要加 sslmode=none 
                var connection = Configuration.GetConnectionString("MysqlConnection");
                services.AddDbContext<DBContext>(options => options.UseMySQL(connection));
                services.AddMvc();
            }

6、获取集合

private readonly DBContext _db;
            //通过.NET Core框架自动为我们做构造函数依赖注入IOC。
            public HomeController(DBContext db)
            {
                _db = db;
            }
            public ActionResult Index()
            {
               var list= _db.student.ToList();
                return View();
            }

![这里写图片描述][70 1]

[70]: /images/20220526/549c76d30127480ba6d3a18314fd0947.png
[70 1]: /images/20220526/79e2f08157c64804b2b8bb074b822677.png