How to maintain database transacton in c#.net 3-tire architecture? - TechRepublic
Question
September 9, 2007 at 10:09 PM
vaibhav.gadre

How to maintain database transacton in c#.net 3-tire architecture?

by vaibhav.gadre . Updated 17 years, 10 months ago

I am developing three-Tier Application Architecture using .NET Remoting,
client doesn’t have connection to database,
every thing written in database side i.e in Stored procedure,client calls application server’s method,app.server calls database SP.
app.serve have static connection object.

In case of master-details transaction saving,if master data insert into databse and while adding detail data error occured then how to rollback all trancations.
I can’t maintain begin-commit transaction.
Please anybody help me….

This discussion is locked

All Comments