.net core
EF core
环境搭建
新建 .Net Core项目。
Nuget添加Entity Framework
Install-Package Microsoft.EntityFrameworkCore
Install-Package Microsoft.EntityFrameworkCore.SqlServer
Install-Package Microsoft.EntityFrameworkCore.Design
Install-Package Microsoft.EntityFrameworkCore.Tools
Database First
基础语法
scaffold "Server=数据库连接地址;Database=数据库名称;Trusted_Connection=True;" Microsoft.EntityFrameworkCore.SqlServer 后续参数......
后续参数
在控制台写入(使用EF操作数据必须设置主键)
Scaffold-DbContext “Server=.; Database=DB;Persist Security Info=True;User ID=sa;password=123123;” Microsoft.EntityFrameworkCore.SqlServer -OutputDir Models
注释掉原有数据库链接
protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
{
if (!optionsBuilder.IsConfigured)
{
#warning To protect potentially sensitive information in your connection string, you should move it out of source code. See http://go.microsoft.com/fwlink/?LinkId=723263 for guidance on storing connection strings.
optionsBuilder.UseSqlServer("Server=.; Database=DB;Persist Security Info=True;User ID=sa;password=123456;");
}
}
在appsettings.json文件中配置数据库连接
"ConnectionStrings": {
"SqlConnection": "Data Source=.;Initial Catalog=DB;User ID=sa;Password=123123;MultipleActiveResultSets=true;"
}
在Startup.cs的ConfigureServices方法中进行注册上下文服务
public void ConfigureServices(IServiceCollection services)
{
services.AddMvc();
services.AddDbContext<DBContext>(options =>options.UseSqlServer(Configuration.GetConnectionString("SqlConnection")));
}