public List <DbMetadataColumn> GetTableColumns(string tableName)
{
List <DbMetadataColumn> columns = new List <DbMetadataColumn>();
using (MssqlWrapper sqlWrapper = new MssqlWrapper(connection.GetConnection() as SqlConnection))
{
var dataReader = sqlWrapper.ExecuteQuery("SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA = @dbname AND TABLE_NAME = @tablename",
new []
{
new SqlParameter("@dbname", sqlWrapper.DatabaseName),
new SqlParameter("@tablename", tableName)
});
DataTable dt = DatabaseHelper.ConvertDataReaderToDataTable(dataReader);
foreach (DataRow dr in dt.Rows)
{
columns.Add(new DbMetadataColumn()
{
ColumnName = dr["COLUMN_NAME"].ToString()
});
}
}
return(columns);
}
private List <DbMetadataTable> GetDatabaseTables()
{
DataTable dt = null;
List <DbMetadataTable> tables = new List <DbMetadataTable>();
using (MssqlWrapper sqlWrapper = new MssqlWrapper(connection.GetConnection() as SqlConnection))
{
var dataReader = sqlWrapper.ExecuteQuery("SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES");
dt = DatabaseHelper.ConvertDataReaderToDataTable(dataReader);
}
foreach (DataRow dr in dt.Rows)
{
string tableName = dr["TABLE_NAME"].ToString();
tables.Add(
new DbMetadataTable()
{
TableName = tableName,
Columns = GetTableColumns(tableName)
});
}
return(tables);
}