Creating ADO.NET Transaction in N-Tier architecture in C#
Posted on 2006-11-22
How do we create ADO.NET Transaction in N-Tier architecture in C#
Like what goes in User Interface layer , what in the middle tier...
My idea is two have sql statements like calling in 2 stored procedures separtely and rollback the total transaction if any one of the stored procedure fails...
I kind of know what to do with only user interface layer but i dont know how to do in N-tier architecture..
Please give me a example of how it can be done this way...