1、配置文件里面配置连接字符串
{
"ConnectionStrings": {
"PurchaseDatabase": "Data Source=.;Initial Catalog=D;uid=sa;pwd=123456;"
//使用sa身份登录 Data Source=.;Initial Catalog=D;uid=sa;pwd=123456;
//使用windows身份登录 Data Source=.;Initial Catalog=D;Integrated Security=True
},
"Logging": {
"LogLevel": {
"Default": "Information",
"Microsoft": "Warning",
"Microsoft.Hosting.Lifetime": "Information"
}
},
"AllowedHosts": "*"
}
2、定义好契约 ISQLUserRepository
3、实现接口并使用DbContext
private readonly DContext _context;
public SQLUserRepository(DContext context)
{
_context = context;
}
4、在启动文件 Startup
//在上面构造函数注入配置类
public IConfiguration _Configuration { get; }
public Startup(IConfiguration configuration)
{
_Configuration = configuration;
}
//得到配置文件的sql连接字符串
services.AddDbContext<DContext>(options =>
options.UseSqlServer(_Configuration.GetConnectionString("PurchaseDatabase")));
//使用 AddScoped 指定用哪个实现了接口的子类,
//AddScoped 特点,在每一个的http请求都是个新的实例
services.AddScoped<ISQLUserRepository, SQLUserRepository>();