/// <summary>
/// 初始化要使用的 Wunion.DataAdapter.NetCore 数据引擎。
/// </summary>
/// <param name="env">用于获到当前请求 Hotting 信息的对象。</param>
/// <param name="configuration">用于读取 appsettings.json 配置文件的对象。</param>
public static void UseDataEngine(IHostingEnvironment env, IConfiguration configuration)
{
IConfigurationSection Section = configuration.GetSection("ConnectionStrings");
SqliteDbAccess SqliteDBA = new SqliteDbAccess();
string wwwroot = env.WebRootPath;
if (wwwroot[wwwroot.Length - 1] != '\\')
{
wwwroot += "\\";
}
SqliteDBA.ConnectionString = Section.GetValue <string>("SQLite").Replace("{wwwroot}", wwwroot);
DataEngine.AppendDataEngine(SqliteDBA, new SqliteParserAdapter()); // 添加为默认引擎。
SqlServerDbAccess MsSqlDBA = new SqlServerDbAccess();
MsSqlDBA.ConnectionString = Section.GetValue <string>("SQLServer");
DataEngine.AppendDataEngine(MsSqlDBA, new SqlServerParserAdapter(), "SQLServer");
MySqlDBAccess MySqlDBA = new MySqlDBAccess();
MySqlDBA.ConnectionString = Section.GetValue <string>("MariaDB");
DataEngine.AppendDataEngine(MySqlDBA, new MySqlParserAdapter(), "MariaDB");
NpgsqlDbAccess NpgsqlDBA = new NpgsqlDbAccess();
NpgsqlDBA.ConnectionString = Section.GetValue <string>("PostgreSQL");
DataEngine.AppendDataEngine(NpgsqlDBA, new NpgsqlParserAdapter(), "PostgreSQL");
}
public static SqlServerDbAccess GetInstance()
{
if (instance == null)
{
instance = new SqlServerDbAccess(SqlConnectionSingleton.GetInstance());
}
return(instance);
}
private void InitializeDataEngine()
{
if (string.IsNullOrEmpty(txt_connection.Text))
{
MessageBox.Show(Language.GetString("NullDbConnection"),
Language.GetString("MsgBoxErrorTitle"),
MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
try
{
DbAccess DBA;
ParserAdapter parserAdapter;
switch (cmb_databaseType.SelectedItem as string)
{
case "Microsoft SQL Server":
DBA = new SqlServerDbAccess();
DBA.ConnectionString = txt_connection.Text.Trim();
parserAdapter = new SqlServerParserAdapter();
codeService = new GeneratorService(DBA, parserAdapter);
codeService.DbContext = new SqlServerDbContext(codeService.DbEngine);
break;
case "SQLite3":
DBA = new Wunion.DataAdapter.Kernel.SQLite3.SqliteDbAccess();
DBA.ConnectionString = txt_connection.Text.Trim();
parserAdapter = new Wunion.DataAdapter.Kernel.SQLite3.CommandParser.SqliteParserAdapter();
codeService = new GeneratorService(DBA, parserAdapter);
codeService.DbContext = new SQLite3DbContext(codeService.DbEngine);
break;
case "PostgreSQL":
DBA = new Wunion.DataAdapter.Kernel.PostgreSQL.NpgsqlDbAccess();
DBA.ConnectionString = txt_connection.Text.Trim();
parserAdapter = new Wunion.DataAdapter.Kernel.PostgreSQL.CommandParser.NpgsqlParserAdapter();
codeService = new GeneratorService(DBA, parserAdapter);
codeService.DbContext = new PostgreSQLDbContext(codeService.DbEngine);
break;
case "MySQL":
DBA = new Wunion.DataAdapter.Kernel.MySQL.MySqlDBAccess();
DBA.ConnectionString = txt_connection.Text.Trim();
parserAdapter = new Wunion.DataAdapter.Kernel.MySQL.CommandParser.MySqlParserAdapter();
codeService = new GeneratorService(DBA, parserAdapter);
codeService.DbContext = new MySQLDbContext(codeService.DbEngine);
break;
}
codeService.Language = Language;
dataGridView1.DataSource = new List <TableInfoModel>();
dataGridView1.DataSource = codeService.AllTables.Distinct(p => p.tableName).ToList();
}
catch (Exception Ex)
{
MessageBox.Show(Ex.Message, Language.GetString("MsgBoxErrorTitle"), MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
protected DataEngine GetDbContext(string dbtype, bool useConnectionPool = true)
{
DbAccess dba = null;
ParserAdapter adapter = null;
switch (dbtype?.ToLower())
{
case "ms-sql":
dba = new SqlServerDbAccess();
dba.ConnectionString = "Server=(local);Database=Wunion.DataAdapter.NetCore.Demo;User ID=sa;Password=ms-sql@(*~-^*);";
adapter = new SqlServerParserAdapter();
break;
case "mysql":
dba = new MySqlDBAccess();
dba.ConnectionString = "Data Source=192.168.1.106;Database=ksdatab;User ID=cnzhnet;Password=mysql@(*~-^*);";
adapter = new MySqlParserAdapter();
break;
case "npgsql":
dba = new NpgsqlDbAccess();
dba.ConnectionString = "Host=192.168.1.106;Username=postgres;Password=npgsql@(*~-^*);Database=Wunion.DataAdapter.NetCore.Demo;";
adapter = new NpgsqlParserAdapter();
break;
case "sqlite3":
dba = new SqliteDbAccess();
dba.ConnectionString = @"Data Source=E:\SQLiteStudio\wdak.sqlite3;";
adapter = new SqliteParserAdapter();
break;
}
if (dba == null || adapter == null)
{
return(null);
}
DataEngine db = new DataEngine(dba, adapter);
if (useConnectionPool)
{
UseConnectionPool(db);
}
return(db);
}
public SysDatabaseQuery(SqlServerDbAccess dbAccess)
{
this.dbAccess = dbAccess;
}
public DbServerManager(SqlServerDbAccess dbAccess)
{
DbAccess = dbAccess;
}
public SysTableQuery(SqlServerDbAccess dbAccess)
{
this.dbAccess = dbAccess;
}
public static void SetInstance(SqlServerDbAccess instance)
{
SqlServerDbAccessSingleton.instance = instance;
}
public SqlServerTable(SqlServerDbAccess dbAccess)
{
DbAccess = dbAccess;
}
