/// <summary> /// 加载数据表 /// </summary> /// <param name="connectionName"></param> private void LoadTable(String connectionName) { // 加载数据库 nowConnectionName = connectionName; var dal = new DbConnConfigDAL(); var model = dal.FindOne(connectionName); this.nowDbSchema = DbSchemaFactory.Create(new MySqlDatabase(model.ConnectionString, MySqlClientFactory.Instance)); try { nowDb = this.nowDbSchema.GetDatabase(model.DefaultDb); } catch (Exception e1) { MsgBox.ShowErrorMessage("数据库打开失败:" + e1.Message); return; } // 加载表 this.listBox1.Items.Clear(); this.listBox2.Items.Clear(); this.unSelectedTableList.Clear(); this.selectedTableList.Clear(); foreach (SOTable t in nowDb.TableList) { listBox1.Items.Add(t); unSelectedTableList.Add(t); } }
/// <summary> /// 加载连接 /// </summary> private void LoadConnection() { var dal = new DbConnConfigDAL(); var connList = dal.FindAll().ToList(); cmbConnectionList.Items.Clear(); foreach (var item in connList) { cmbConnectionList.Items.Add(item.Name); } var tmpIndex = connList.FindIndex(tmp => tmp.Name == nowConnectionName); if (tmpIndex >= 0) { cmbConnectionList.SelectedIndex = tmpIndex; LoadTable(connList[tmpIndex].Name); } else { //清理相关数据 this.listBox1.Items.Clear(); this.listBox2.Items.Clear(); this.unSelectedTableList.Clear(); this.selectedTableList.Clear(); } }
/// <summary> /// 创建一个数据提供程序实例 /// </summary> /// <param name="connectionStringName"></param> /// <returns></returns> public static Database Create(string connectionStringName) { CheckUtil.ArgumentNotNullOrEmpty(connectionStringName, "connectionStringName"); DbConnConfigDAL dal = new DbConnConfigDAL(); var model = dal.FindOne(connectionStringName); if (model == null) { throw new Exception(string.Format(Resources.Data.ConnectionStringNameNotFound, connectionStringName)); } string connectionString = model.ConnectionString; string providerName = model.ProviderName; Database db = new SqlServerDatabase(connectionString); DbProviderFactory providerFactory = null; if (string.IsNullOrEmpty(providerName)) { return(db); } //if (css.ProviderName == "System.Data.OleDb") //{ // providerFactory = OleDbFactory.Instance; //} //else //{ // providerFactory = DbProviderFactories.GetFactory(css.ProviderName); //} //if (providerFactory == null) throw new Exception(string.Format(Resources.Data.DataProviderNotFound, css.ProviderName)); switch (providerName) { //case "System.Data.SqlClient": // break; case "System.Data.Odbc": db = new OdbcDatabase(connectionString); break; case "System.Data.OleDb": db = new OleDbDatabase(connectionString); break; case "System.Data.SQLite": providerFactory = DbProviderFactories.GetFactory(providerName); db = new SQLiteDatabase(connectionString, providerFactory); break; case "MySql.Data.MySqlClient": providerFactory = DbProviderFactories.GetFactory(providerName); db = new MySqlDatabase(connectionString, providerFactory); break; case "IBM.Data.DB2": providerFactory = DbProviderFactories.GetFactory(providerName); db = new DB2Database(connectionString, providerFactory); break; case "FirebirdSql.Data.FirebirdClient": providerFactory = DbProviderFactories.GetFactory(providerName); db = new FirebirdDatabase(connectionString, providerFactory); break; default: break; } return(db); }