54 lines
1.9 KiB
C#
54 lines
1.9 KiB
C#
using Microsoft.EntityFrameworkCore;
|
||
using Mini.Common;
|
||
using Mini.Model.WxEntity;
|
||
using MySql.Data.MySqlClient;
|
||
using System;
|
||
using System.Collections.Generic;
|
||
using System.Data;
|
||
using System.Text;
|
||
|
||
namespace Mini.Model
|
||
{
|
||
public class wxContext : DbContext
|
||
{
|
||
public wxContext(DbContextOptions<wxContext> options) : base(options)
|
||
{
|
||
|
||
}
|
||
public wxContext()
|
||
{
|
||
|
||
}
|
||
protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
|
||
{
|
||
optionsBuilder.UseMySQL(Utility.GetSettingByKey("ConnectionStrings:wxContext"));
|
||
base.OnConfiguring(optionsBuilder);
|
||
}
|
||
|
||
|
||
public DbSet<Wx_WorkAccount> Wx_WorkAccount { get; set; }
|
||
public DbSet<Wx_Alive> Wx_Alive { get; set; }
|
||
public DbSet<Wx_JobuserLastFriend> Wx_JobuserLastFriend { get; set; }
|
||
public DbSet<Wx_LastMsgTime> Wx_LastMsgTime { get; set; }
|
||
public DbSet<Mini.Model.WxEntity.Bas_Parameter> Bas_Parameter { get; set; }
|
||
public DbSet<Mini.Model.WxEntity.Wx_Rcontact> Wx_Rcontact { get; set; }
|
||
|
||
|
||
|
||
//自定义DbContext实体属性名与数据库表对应名称（默认 表名与属性名对应是 User与Users）
|
||
protected override void OnModelCreating(ModelBuilder modelBuilder)
|
||
{
|
||
modelBuilder.Entity<Wx_WorkAccount>().ToTable("Wx_WorkAccount".ToLower());
|
||
modelBuilder.Entity<Wx_Alive>().ToTable("Wx_Alive".ToLower());
|
||
modelBuilder.Entity<Wx_JobuserLastFriend>().ToTable("Wx_JobuserLastFriend".ToLower());
|
||
modelBuilder.Entity<Wx_LastMsgTime>().ToTable("Wx_LastMsgTime".ToLower());
|
||
modelBuilder.Entity<Mini.Model.WxEntity.Bas_Parameter>().ToTable("Bas_Parameter".ToLower());
|
||
modelBuilder.Entity<Mini.Model.WxEntity.Wx_Rcontact>().ToTable("Wx_Rcontact".ToLower());
|
||
|
||
base.OnModelCreating(modelBuilder);
|
||
}
|
||
|
||
}
|
||
|
||
}
|