public class MyDBContext:DbContext { public MyDBContext(DbContextOptions<MyDBContext> opt) :base(opt) { } public DbSet<Product> Products { get; set; } ... }
2、.netCore 中引用 Startup.cs中ConfigureServices 注入EF Core服务
public void ConfigureServices(IServiceCollection services) { services.AddDbContext<Sport.Entity.SportStoreDBContext>(opt => opt.UseSqlServer(Configuration.GetConnectionString("SportDB"))//appsettings.json ConnectionStrings.SportDB ) ; ... }
appsettings.json 中配置ConnectionStrings 节点值
{ "Logging": { "LogLevel": { "Default": "Information", "Microsoft": "Warning", "Microsoft.Hosting.Lifetime": "Information" } }, "AllowedHosts": "*", "ConnectionStrings": { "SportDB": "Server=(localdb)\\ProjectsV13;database=MyPracticeDB;Trusted_Connection=True;MultipleActiveResultSets=true" } }
3 页面中调用,net Core 将EF服务,以构造函数的方式提供调用
private readonly SportStoreDBContext _sportContext;
public HomeController(SportStoreDBContext sportContext)
{
_sportContext = sportContext;
}
//调用
public ActionResult List()
{
var list = _sportContext.Product.ToList();
}