ApplicationDbContext配置

一、appsetting.json 声明连接字符串

?

1 2 3

"ConnectionStrings": {    "DefaultConnection": "Server=DESKTOP-DABHN6U\\MSSQLSERVER2014;uid=sa;pwd=Lz38275292;database=SPA;MultipleActiveResultSets=true;;TrustServerCertificate=<code class="csharp keyword">true</code>"  },

二、创建上下文类 ApplicationDbContext 

?

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47

public class ApplicationDbContext : DbContext    {        public ApplicationDbContext(DbContextOptions options) : base(options)        {          }          public DbSet<MemberInfo> Members { get; set; }        public DbSet<PostInfo> PostInfos { get; set; }          protected override void OnConfiguring(DbContextOptionsBuilder options)        {            options.EnableSensitiveDataLogging(true);//错误信息中启用敏感数据记录        }          protected override void OnModelCreating(ModelBuilder modelBuilder)        {            base.OnModelCreating(modelBuilder);            //设置组合主键            List<string> keys = new List<string>();            keys.Add(nameof(CardHistoryConsumptionInfo.会员编号));            keys.Add(nameof(CardHistoryConsumptionInfo.流水号));            keys.Add(nameof(CardHistoryConsumptionInfo.销售单明细ID));            modelBuilder.Entity<CardHistoryConsumptionInfo>().HasKey(keys.ToArray());              keys = new List<string>();            keys.Add(nameof(StockInfo.年));            keys.Add(nameof(StockInfo.月));            keys.Add(nameof(StockInfo.会所编号));            keys.Add(nameof(StockInfo.仓库编号));            keys.Add(nameof(StockInfo.物品编号));            modelBuilder.Entity<StockInfo>().HasKey(keys.ToArray());              keys = new List<string>();            keys.Add(nameof(AnotherNameInfo.表名));            keys.Add(nameof(AnotherNameInfo.字段名));            modelBuilder.Entity<AnotherNameInfo>().HasKey(keys.ToArray());              keys = new List<string>();            keys.Add(nameof(EmployeePerformanceInfo.流水号));            keys.Add(nameof(EmployeePerformanceInfo.员工编号));            modelBuilder.Entity<EmployeePerformanceInfo>().HasKey(keys.ToArray());              // 配置表名映射            modelBuilder.Entity<MemberInfo>().ToTable(MemberInfo.TableName);                   }

　三、注入服务 Program.cs

?

1 2	builder.Services.AddDbContext<ApplicationDbContext>(options =>     options.UseSqlServer(builder.Configuration.GetConnectionString("DefaultConnection")));