c#WebAPI项目中使用EFCORE orm来读取和写入,数据库操作

创建dbContext实例

建立文件夹

MysqlDBcontext.cs 文件

※dbContext 不要和 DbContext 重复

namespace ShopeeChatService.dbContext
{
      public class MysqlDBcontext : DbContext
      {
            public MysqlDBcontext(DbContextOptions<MysqlDBcontext> options)
            : base(options) { }

            public Dset<person> persons {get;set;}

      }
      public class person
      {
            public int id {get;set;}
            public string name {get;set;}
      }
}

入口文件增加

引入包

1.Microsoft.EntityFrameworkCore

2.Pomelo.EntityFrameworkCore.MySql

3.Microsoft.EntityFrameworkCore.Tool

Program.cs 中增加如下代码

builder.Services.AddDbContext<MySqlDbContext>(options =>
{
    string connectionString = "server=localhost;port=3306;uid=root;pwd=123456;database=xxxx;AllowLoadLocalInfile=true";
    var serverVersion = ServerVersion.AutoDetect(connectionString);
    options.UseMySql(connectionString, serverVersion);
});

builder.Services.AddEndpointsApiExplorer();
builder.Services.AddSwaggerGen();
builder.Services.AddCors(options =>
{
    options.AddPolicy("AllowAll", builder =>
    {
        builder.AllowAnyOrigin()
               .AllowAnyMethod()
               .AllowAnyHeader();
    });
});

这样在你程序中就可以用这个EF实例来操作数据库了

public class program
{
      private readonly MysqlDBcontext _dbContext;
      public program(MysqlDBcontext dbContext)
        {
            _dbContext = dbContext;
        }

        public void Main()
        {
            // 获取所有的清单
            var persons = _dbContext.persons.Tolist();

            // 增加新记录到表中
            // person p = new ()
            {
                name ="Jack"  
            };
            _dbContext.persons.add(p)
            _dbContext.savechanges();
        }
}