private static void InitDB() { if (_DB == null) { _DB = new Dictionary <String, SqlBase>(); } if (_DB.Count > 0) { return; } foreach (ConnectionStringSettings css in MyDbSetting.GetAllConnections()) { SqlBase sb = null; switch (MyDbSetting.GetProviderType(css.ProviderName)) { case ProviderType.MsSql: sb = new MsSql(MyDbSetting, css.Name); break; case ProviderType.OleDb: sb = new OleDb(MyDbSetting, css.Name); break; case ProviderType.Odbc: sb = new Odbc(MyDbSetting, css.Name); break; case ProviderType.Oracle: sb = new Oracle(MyDbSetting, css.Name); break; case ProviderType.MySql: sb = new MySql(MyDbSetting, css.Name); break; } sb.DSS = MyDss; if (sb != null) { if (!_DB.ContainsKey(css.Name)) { _DB.Add(css.Name, sb); } } } }
public static SqlBase NewDB(ProviderType providerType, String connectionString) { SqlBase sb = null; switch (providerType) { case ProviderType.MsSql: sb = new MsSql(connectionString); break; case ProviderType.OleDb: sb = new OleDb(connectionString); break; case ProviderType.Odbc: sb = new Odbc(connectionString); break; case ProviderType.Oracle: sb = new Oracle(connectionString); break; case ProviderType.MySql: sb = new MySql(connectionString); break; } sb.DSS = MyDss; return(sb); }