public static IList <SISColumn> GetInformationSchemaColumns(SqlTableReference sqlTableReference)
{
var sqlQuery =
InformationSchemaMetadataSqlQueryGenerator.GetInformationSchemaColumnsSqlQuery(sqlTableReference);
var tableColumns = sqlTableReference.SqlConnectionProvider.Query <SISColumn>(sqlQuery)
.ToList();
return(tableColumns);
}
public static SISTable GetInformationSchemaTable(SqlTableReference sqlTableReference)
{
var sqlQuery =
InformationSchemaMetadataSqlQueryGenerator.GetInformationSchemaTableSqlQuery(sqlTableReference);
var tables = sqlTableReference.SqlConnectionProvider.Query <SISTable>(sqlQuery).ToList();
CheckOnlyOneTableWasReturned(tables);
return(tables.SingleOrDefault());
}
