Exemplo n.º 1
0
 public static bool IndexExists(this IDataSyntax syntax, string name)
 {
     return(syntax.Table("sys", "indexes").Exists(new { name = name }));
 }
Exemplo n.º 2
0
 public static bool ForeignKeyExists(this IDataSyntax syntax, string name)
 {
     return(syntax.Table("INFORMATION_SCHEMA", "REFERENTIAL_CONSTRAINTS").Exists(new { CONSTRAINT_NAME = name }));
 }
Exemplo n.º 3
0
 public static bool UniqueConstraintExists(this IDataSyntax syntax, string name)
 {
     return(syntax.Table("INFORMATION_SCHEMA", "TABLE_CONSTRAINTS").Exists(new { CONSTRAINT_NAME = name, CONSTRAINT_TYPE = "UNIQUE" }));
 }
Exemplo n.º 4
0
 public static IDataTableSyntax Table(this IDataSyntax syntax, string schema, string table)
 {
     return(syntax.InSchema(schema).InTable(table));
 }