public DisabledForeignKeyCheckContext(SqlTransactionalCommandsContext context)
{
this.context = context;
var command = ((DefaultSqlTransactionalCommandsContext)context).DbConnection.CreateCommand();
// LogicalNot Azure compatible - command.CommandText = "EXEC sp_msforeachtable \"ALTER TABLE ? NOCHECK CONSTRAINT all\"";
command.CommandText =
@"DECLARE @table_name SYSNAME;
DECLARE @cmd NVARCHAR(MAX);
DECLARE table_cursor CURSOR FOR SELECT name FROM sys.tables;
OPEN table_cursor;
FETCH NEXT FROM table_cursor INTO @table_name;
WHILE @@FETCH_STATUS = 0 BEGIN
SELECT @cmd = 'ALTER TABLE '+QUOTENAME(@table_name)+' NOCHECK CONSTRAINT ALL';
EXEC (@cmd);
FETCH NEXT FROM table_cursor INTO @table_name;
END
CLOSE table_cursor;
DEALLOCATE table_cursor;";
command.ExecuteNonQuery();
}
public DisabledForeignKeyCheckContext(SqlTransactionalCommandsContext context)
{
var command = ((DefaultSqlTransactionalCommandsContext)context).CreateCommand();
command.CommandText = "SET CONSTRAINTS ALL DEFERRED;";
command.ExecuteNonQuery();
}
public DisabledForeignKeyCheckContext(SqlTransactionalCommandsContext context)
{
this.context = context;
var command = ((DefaultSqlTransactionalCommandsContext)context).DbConnection.CreateCommand();
command.CommandText = "SET FOREIGN_KEY_CHECKS = 0;";
command.ExecuteNonQuery();
}
public DisabledForeignKeyCheckContext(SqlTransactionalCommandsContext context)
{
this.context = context;
using (var command = ((DefaultSqlTransactionalCommandsContext)context).CreateCommand())
{
command.CommandText = "PRAGMA foriegn_keys = OFF;";
command.ExecuteNonQuery();
}
}
public override IDisabledForeignKeyCheckContext AcquireDisabledForeignKeyCheckContext(SqlTransactionalCommandsContext sqlDatabaseCommandsContext)
{
return new DisabledForeignKeyCheckContext(sqlDatabaseCommandsContext);
}
public abstract IDisabledForeignKeyCheckContext AcquireDisabledForeignKeyCheckContext(SqlTransactionalCommandsContext sqlDatabaseCommandsContext);
public MarsDbCommand(SqlTransactionalCommandsContext context, IDbCommand inner)
: base(inner)
{
this.context = context;
}
public MarsDbCommand(SqlTransactionalCommandsContext context, IDbCommand inner)
: base(inner)
{
this.context = context;
}
public abstract IDisabledForeignKeyCheckContext AcquireDisabledForeignKeyCheckContext(SqlTransactionalCommandsContext sqlDatabaseCommandsContext);
public DisabledForeignKeyCheckContext(SqlTransactionalCommandsContext context)
{
}
