环境配置,
安装好以下Nuget包:
MySql.Data.EntityFrameworkCore
MySql.Data
给程序按照EF风格添加DbContext如下
public class Data
{
[Key]
public int Id { get; set; }
public string Annotation { get; set; }
}
public class DataContext:DbContext
{
public DataContext(DbContextOptions<DataContext> options) : base(options)
{ }
public DbSet<Data> DataSet { get; set; }
}
再ConfigureServices中添加以下项目
services.AddDbContext<ProtocalDataContext>(options =>
options.UseMySQL(Configuration.GetConnectionString("DefaultConnection")));
其中DefaultConnection定义在appsettings.json中
"ConnectionStrings": {
"DefaultConnection": "此处输入连接字符串"
}
然后再nuget 命令控制台(工具-