protected List <TSchemaConstraint> FetchTableConstraints <TSchemaConstraint>(InfoSchemaTable table) where TSchemaConstraint : InfoSchemaTableConstraint, new() { return(_dbManager.Sql() .Select() .AllColumns() .From .Table <TSchemaConstraint>("Constraints") .Where .Criteria("ConstraintSchema", SqlOperand.Equal, table.TableSchema) .Criteria("ConstraintCatalog", SqlOperand.Equal, table.TableCatalog) .Criteria("TableName", SqlOperand.Equal, table.TableName) .Execute <TSchemaConstraint>()); }
protected List <TSchemaColumn> FetchTableColumns <TSchemaColumn>(InfoSchemaTable table) where TSchemaColumn : InfoSchemaColumn, new() { return(_dbManager.Sql() .Select() .AllColumns() .From .Table <TSchemaColumn>("Columns") .Where .Criteria("TableSchema", SqlOperand.Equal, table.TableSchema) .Criteria("TableCatalog", SqlOperand.Equal, table.TableCatalog) .Criteria("TableName", SqlOperand.Equal, table.TableName) .OrderBy .Column("OrdinalPosition") .Execute <TSchemaColumn>()); }