.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")));
        }