public static async Task <IList <TableConstraintInfoDto> > GetAllTableConstraints(ISqlConnectionProvider scp)
{
var query = TableConstraintInfoDto.SqlQuery;
var result = scp.Query <TableConstraintInfoDto>(query).ToList();
return(result);
}
private static IList <SqlSysType> GetSysTypesFromDatabase(ISqlConnectionProvider sqlConnectionProvider, IEnumerable <DescribeResultSetRow> resultColumns)
{
var sysTypes = sqlConnectionProvider
.Query <SqlSysType>("select * from sys.types")
.ToList();
return(sysTypes);
}
public static IList <SISTable> GetInformationSchemaTablesOnly(
ISqlConnectionProvider sqlConnectionProvider)
{
var informationSchemaTables = sqlConnectionProvider
.Query <SISTable>("SELECT * FROM INFORMATION_SCHEMA.TABLES")
.ToList();
return(informationSchemaTables);
}
private static List <SISColumn> GetAllColumns(ISqlConnectionProvider sqlConnectionProvider)
{
var informationSchemaColumns = sqlConnectionProvider
.Query <SISColumn>(
"SELECT * FROM INFORMATION_SCHEMA.COLUMNS ORDER BY TABLE_NAME, ORDINAL_POSITION")
.ToList();
return(informationSchemaColumns);
}
private static List <SISTable> GetAllTables(ISqlConnectionProvider sqlConnectionProvider)
{
var informationSchemaTables = sqlConnectionProvider
.Query <SISTable>(
"SELECT * FROM INFORMATION_SCHEMA.TABLES ORDER BY TABLE_SCHEMA, TABLE_NAME")
.ToList();
return(informationSchemaTables);
}
public static IEnumerable <T> MyQuery <T>(this ISqlConnectionProvider sqlConnectionProvider,
string whereClause = null,
string tableName = null,
string schemaName = null)
{
whereClause = whereClause ?? "1 = 1";
var selectClause = GenerateSelectClause <T>();
tableName = SqlTextFunctions.GetTableName(typeof(T), tableName, schemaName);
var sqlStatement = $"SELECT {selectClause} FROM {tableName} WHERE {whereClause}";
SqlLogger.LogSqlStatement(sqlStatement);
var results = sqlConnectionProvider.Query <T>(sqlStatement).ToList();
return(results);
}
