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