<div>
I didnt know that i had to close the question. Sorry abt that..
</div>


I didnt know that i had to close the question. Sorry abt that..

<div>
<div class="content wysiwyg-content">
How do we create ADO.NET Transaction in N-Tier architecture in C#<br />
<br />
Like what goes in User Interface layer , what in the middle tier...<br />
<br />
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...<br />
<br />
I kind of know what to do with only user interface layer but i dont know how to do in N-tier architecture..<br />
<br />
Please give me a example of how it can be done this way...<br />
<br />
Thanks,<br />
prasad<br />
<br />

</div>
</div>


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...

Thanks,
prasad



Creating ADO.NET Transaction in N-Tier architecture in C#

The successor to Active Server Pages, ASP.NET websites utilize the .NET framework to produce dynamic, data and content-driven web applications and services. ASP.NET code can be written using any .NET supported language. As of 2009, ASP.NET can also apply the Model-View-Controller (MVC) pattern to web applications