private static DataTable GetTableData(string tableName)
{
DataTable tableData = new DataTable(tableName);
using (SqlConnection conn = new SqlConnection("context connection=true"))
{
conn.Open();
DBDataSourceReader sqlReader = new DBDataSourceReader(tableName);
tableData = sqlReader.GetDataTable(conn);
conn.Close();
}
return(tableData);
}
private static List <ColumnSchema> GetTableSchema(string tableName)
{
List <ColumnSchema> tblSchemas = new List <ColumnSchema>();
using (SqlConnection conn = new SqlConnection("context connection=true"))
{
conn.Open();
DBDataSourceReader sqlReader = new DBDataSourceReader(tableName);
tblSchemas = sqlReader.GetDataSchema(conn);
conn.Close();
}
return(tblSchemas);
}
