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