public IList <T> SelectSchemaInfo <T>(InformationType infoType) { Logger.Info($"Selecting basic schema information of type: {infoType}"); var queryBuilder = SqlBuilderFactory.Create(DbType, Database.ConnectionString); Sql sqlQuery = queryBuilder.GetSqlQueryString(infoType); try { using (var db = Database) { Logger.Info($"Querying database with {sqlQuery}"); var queryResult = db.Query <T>(sqlQuery).ToList(); return(queryResult); } } catch (SqlException exception) { Logger.Warn(exception, $"Unable to retrieve basic schema information of type {infoType} from database."); return(null); } catch (Exception exception) { Logger.Warn(exception, "Unexpected error."); return(null); } }
private void setDatagridviewTables() { SqlBuilderFactory sqlFactory = new SqlBuilderFactory(GetServer()); ISqlBuilder sqlBuilder = sqlFactory.Create(GetSqlConnection().Database); dataGridViewTables.DataSource = DbUtils.getDataTableData(GetSqlConnection(), sqlBuilder.getDatabaseTables()); }
/// <summary> /// 切换数据库类型 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void comboBox_dbType_SelectedIndexChanged(object sender, EventArgs e) { _dbType = comboBox_dbType.Text; _sqlBuilder = SqlBuilderFactory.Create(_dbType); }
public Form1() { InitializeComponent(); _sqlBuilder = SqlBuilderFactory.Create(_dbType); }