public IDbConnection CreateConnection()
{
var setting = AppConfig.Instance.DatabaseSetting;
var connectionString = AppDbConnectionBuilder.Build(setting);
var dbType = setting.DatabaseType.ToLower();
if (dbType == "postgres")
{
return(new NpgsqlConnection(connectionString));
}
else if (dbType == "sqlserver")
{
return(new SqlConnection(connectionString));
}
else if (dbType == "sqlserver")
{
return(new SqlConnection(connectionString));
}
else if (dbType == "mysql")
{
return(new MySqlConnection(connectionString));
}
else
{
}
return(null);
}
protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
{
ConnectionString = AppDbConnectionBuilder.Build(Setting);
var dbType = Setting.DatabaseType.ToLower();
if (dbType == "postgres")
{
optionsBuilder
.UseLoggerFactory(new MyLoggerFactory())
.UseNpgsql(ConnectionString);
}
else if (dbType == "sqlserver")
{
optionsBuilder
.UseLoggerFactory(new MyLoggerFactory())
.UseSqlServer(ConnectionString);
}
else if (dbType == "mysql")
{
optionsBuilder
.UseLoggerFactory(new MyLoggerFactory())
.UseMySQL(ConnectionString);
}
else
{
}
}