public void Execute()
{
using (var sqlConnection = new SqlConnector().Connect(_connectionString))
{
SqlConstraints.DisableAllConstraints(sqlConnection);
using (var command = sqlConnection.CreateCommand())
{
command.CommandType = CommandType.Text;
command.CommandText = @"Exec sp_MSForEachTable
'
If ObjectProperty(Object_ID(''?''), ''TableHasForeignRef'') = 1
Begin
-- Just to know what all table used delete syntax.
Print ''Delete from '' + ''?''
Delete From ?
End
Else
Begin
-- Just to know what all table used Truncate syntax.
Print ''Truncate Table '' + ''?''
Truncate Table ?
End
'";
command.ExecuteNonQuery();
}
SqlConstraints.EnableAllConstraints(sqlConnection);
}
}
public void Execute()
{
using (var connection = new SqlConnector().Connect(_connectionString))
{
SqlConstraints.DisableAllConstraints(connection);
Execute(connection);
SqlConstraints.EnableAllConstraints(connection);
}
}
