IT:AD:SQL Server:HowTo:Run a Transaction Without Committing
- See also:
Summary
Sometimes CodeFirst Migrations cocks up.
Process
BEGIN TRANSACTION;
BEGIN TRY
...
END TRY
BEGIN CATCH
SELECT ERROR_MESSAGE();
SELECT ERROR_LINE();
IF @@TRANCOUNT > 0
ROLLBACK TRANSACTION;
END CATCH;
IF @@TRANCOUNT > 0
-- COMMIT TRANSACTION;