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);
}
