c# - Enforce transactions for write operations in SQL Server -
how ensure , enforce write operations ms sql server db transactions-based?
the reason want db contains financial account data , operations fail halfway through set of changes should not able mess database mistake or crashing.
the application written in asp.net c#.
thanks.
edit: there dal not (yet) require transactions changes. wrote dal ourselves. did not use orm.
i know how perform 1 transaction asp.net.
i want ensure all changes made in transaction form if application throws exception in middle, there no change database.
you might want @ setting sql server use implicit transactions: http://msdn.microsoft.com/en-us/library/ms188317.aspx
Comments
Post a Comment