protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
{
if (!optionsBuilder.IsConfigured)
{
optionsBuilder.UseSqlServer(ConnConfig.GetConnection());
}
}
/// <summary>
/// 构造函数
/// </summary>
/// <param name="connConfig">数据库链接配置结构</param>
public SqliteAccess(ConnConfig connConfig)
{
if (connConfig.enum_dbType == EnumDbType.SQLite)
{
connStr = connConfig.str_ConnStr;
}
}
/// <summary>
/// 构造函数
/// </summary>
/// <param name="connConfig">数据库链接配置结构</param>
public SqlAccess(ConnConfig connConfig)
{
if (connConfig.enum_dbType == EnumDbType.SqlServer)
{
connStr = connConfig.str_ConnStr;
}
}
/// <summary>
/// 构造函数
/// </summary>
/// <param name="connConfig">数据库链接配置结构</param>
public MySqlAccess(ConnConfig connConfig)
{
if (connConfig.enum_dbType == EnumDbType.MySql)
{
connStr = connConfig.str_ConnStr;
}
}
/// <summary>
/// 构造函数
/// </summary>
/// <param name="connConfig">数据库链接配置结构</param>
public OrclAccess(ConnConfig connConfig)
{
if (connConfig.enum_dbType == EnumDbType.Oracle)
{
connStr = connConfig.str_ConnStr;
}
}
public AccelaDBContext CreateDbContext(string[] args)
{
var optionsBuilder = new DbContextOptionsBuilder <AccelaDBContext>();
optionsBuilder.UseSqlServer(ConnConfig.GetConnection());
return(new AccelaDBContext(optionsBuilder.Options));
}
/// <summary>
/// 根据配置文件来创建数据库帮助类
/// </summary>
/// <param name="name">配置文件中的数据库连接名称</param>
/// <returns></returns>
public static DatabaseHelper CreateByConnName(string name)
{
List <ConnConfig> lst = GlobalConfig.AppCfg.getListByPath <ConnConfig>("configuration/DB/ConnStrings/ConnString");
ConnConfig cfg = lst.Find(l => l.name == name);
if (cfg != null)
{
return(CreateByConnStr(cfg.str, cfg.type));
}
return(null);
}
public void JsonSave()
{
var config = new ConnConfig
{
Key1 = "xyz-yop",
Key2 = "http://abc.com"
};
var result = new JsonShell <ConnConfig>().Save(config, @"C:\Dev\Configs\test.json");
Assert.True(result);
}
static void Main(string[] args)
{
var builder = new ConfigurationBuilder()
.SetBasePath(AppContext.BaseDirectory)
.AddJsonFile("appsettings.json", true, true);
Configuration = builder.Build();
var connConfig = new ConnConfig();
Configuration.GetSection("ConnConfig").Bind(connConfig);
Pack pack = new Pack(connConfig.NumConnections, connConfig.ReceiveBufferSize,
connConfig.Overtime, connConfig.Port, 0xff);
Console.WriteLine("服务端已准备好!");
Console.Read();
}
/// <summary>
/// 构造函数
/// </summary>
/// <param name="connConfig">数据库链接配置结构</param>
public DbAccess(ConnConfig connConfig)
{
connStr = connConfig.str_ConnStr;
dbType = connConfig.enum_dbType;
}
