May 17, 2010 04:41 PM|atconway|LINK
i go through in above three step but if any error occure during inserting record in database,then no rollback working here.for example if i try to insert record in two table and error occure inserting record in second table then first table record is insering
but not in second table.
I am not sure if you tried to use transactions and write the code and design from scratch, but I would begin by modeling the MSDN code examples on using Transactions. It is not that it is incompatible with an n-layer design, but more of how you have implemented
the code. Take a look to the following links, and go through the code examples. I even recommend starting from scratch with a test application using the code examples from the MSDN to get transactions working the way intended. Then try an re-inject the
working code into your application.
Implementing an Implicit Transaction using Transaction Scope:
Writing a Transactional Application: