How to maintain database transacton in 3-tire architecture?

By vaibhav.gadre ·
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 conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Related Discussions

Related Forums