EF core链接SQL Server

一、Sql Server

1.添加实体类

public class UserInfo
    {
        public int Id { get; set; }
        [Required]
        [Display(Name = "名:")]
        public string FirstName { get; set; }
        [Required]
        [Display(Name = "姓:")]
        public string LastName { get; set; }
        [Display(Name = "出生日期:")]
        public DateTime BirthDate { get; set; }
        [Display(Name = "性别:")]
        public bool Gender { get; set; }
    }

2.添加DbContext

public class DataContext:DbContext
    {
        public DataContext(DbContextOptions<DataContext> options) : base(options)
        {
        }

        public DbSet<UserInfo> UserInfo { get; set; }
    }

3.打开appsetting.json,添加连接字符串（SqlServer）

{
  "Logging": {
    "LogLevel": {
      "Default": "Warning"
    }
  },
  "AllowedHosts": "*",
  "ConnectionStrings": {
    "DefaultConnection": "server=服务器名;database=数据库名;uid=用户名;pwd=密码;" 
  }
}

 

4.打开Startup.cs

       //依赖注入
　　　　 private readonly IConfiguration Configuration;
        public Startup(IConfiguration configuration)
        {
            Configuration = configuration;
        } 
        public void ConfigureServices(IServiceCollection services)
        {  
　　　　　　　　//注册服务
　　　　　　  services.AddDbContext<DataContext>(
                options =>
                {
                    options.UseSqlServer(Configuration.GetConnectionString("DefaultConnection"));
                }
            );
　　　　　}