.NET Core配置连接字符串和获取数据库上下文实例_实用技巧_

 public class User { public int Id { get; set; } public string Name { get; set; } public string Number { get; set; } public string Email { get; set; } } public class Blogs { public int Id { get; set; } public string BolgName { get; set; } public string Url { get; set; } }

 public class DataContext : DbContext { public DataContext() { } public DataContext(DbContextOptions options) : base(options) { } public DbSet Users { get; set; } public DbSet Blogs { get; set; } protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder) { base.OnConfiguring(optionsBuilder); } protected override void OnModelCreating(ModelBuilder modelBuilder) { base.OnModelCreating(modelBuilder); } /* * 其他实现 */ }

 services.AddDbContext(options=>options.UseSqlite("filename=Database.db"));

 [ApiController] [Route("[controller]")] public class WeatherForecastController : ControllerBase { private readonly DataContext _context; public WeatherForecastController(DataContext context) { _context = context; } }

Microsoft.Extensions.DependencyInjection

 public class ContextService { /// 
 /// 配置各种服务 /// 
 ///  public static IServiceProvider ServiceProvider() { IServiceCollection services = new ServiceCollection(); services.AddDbContext(options => options.UseSqlite("filename=Database.db")); var serviceProvider = services.BuildServiceProvider(); return serviceProvider; } /// 
 /// 获取上下文 /// 
 ///  ///  public static DataContext GetContext(IServiceProvider services) { var sqliteContext = services.GetService(); return sqliteContext; } /// 
 /// 获取上下文 /// 
 public static DataContext GetContext() { var services = ServiceProvider(); var sqliteContext = services.GetService(); return sqliteContext; } }

 var context = ContextService.GetContext(); var list = context.Users.ToList();

options => options.UseSqlite("filename=Database.db")

 protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder) { #if DEBUG optionsBuilder.UseSqlite("filename=Database.db"); #endif }

 var context = new DataContext(); var list = context.Users.ToList();

 public DataContext(DbContextOptions options) : base(options) { }

 services.AddDbContext(options=>options.UseSqlite("filename=Database.db"));

 var optionsBuilder = new DbContextOptionsBuilder(); optionsBuilder.UseSqlite("filename=Database.db"); DataContext context = new DataContext(optionsBuilder.Options); var list = context.Users.ToList();