private static void AddSqlOperation(this IDbMigration migration, string sql, bool suppressTransaction = false, object anonymousArguments = null) { var operation = new SqlOperation(sql, anonymousArguments) { SuppressTransaction = suppressTransaction }; migration.AddOperation(operation); }
public static void DeleteDefaultContraint(this IDbMigration migration, string tableName, string colName, bool suppressTransaction = false) { var sql = new SqlOperation(String.Format(@"DECLARE @SQL varchar(1000) SET @SQL='ALTER TABLE {0} DROP CONSTRAINT ['+(SELECT name FROM sys.default_constraints WHERE parent_object_id = object_id('{0}') AND col_name(parent_object_id, parent_column_id) = '{1}')+']'; PRINT @SQL; EXEC(@SQL);", tableName, colName)) { SuppressTransaction = suppressTransaction }; migration.AddOperation(sql); }
public static void Comment(this IDbMigration migration, string text, object anonymousArguments = null) { migration.AddOperation(new CommentOperation(text, anonymousArguments)); }
public static RemoveOperation Remove(this PatchDocument obj, string pathToMove) { RemoveOperation operation = new RemoveOperation(new Path(pathToMove)); obj.AddOperation(operation); return operation; }
public static AppendOperation AppendTo(this PatchDocument obj, string path) { AppendOperation operation = new AppendOperation(new Path(path)); obj.AddOperation(operation); return operation; }
//Add operation public static AddOperation Add(this PatchDocument obj, string pathToAdd) { AddOperation operation = new AddOperation(new Path(pathToAdd)); obj.AddOperation(operation); return operation; }
//Test Operation public static TestOperation Test(this PatchDocument obj, string pathToMove) { TestOperation operation = new TestOperation(new Path(pathToMove)); obj.AddOperation(operation); return operation; }
// Move Operation public static MoveOperation Move(this PatchDocument obj, string pathToMove) { MoveOperation operation = new MoveOperation(pathToMove); obj.AddOperation(operation); return operation; }