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….