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