ASP.NET & SQL SERVER 2005 - Transaction on the client level and not database level
Posted on 2011-05-04
I have two SQL Server 2005 tables, Orders and Order_Details.
I am using ASP.NET and dealing with the tables with Stored Procedures.
I want to save an order and its details in a transaction, that if a failure happens, the whole transaction rolls back and not to save part of the orders.
My problem is that since the database calls are happening individually, ie. Each row of the order details grid is read and sent at once, how can I do a transaction on that level?
Thanks in advance,