Questions

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

Tags:
+
0 Votes
Locked

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

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....
  • +
    0 Votes

    hi

    manasachowdary6

    The string was not recognized as a valid DateTime. There is a unknown word starting at index 10.(this is my error but every thing in sp is correct and as well as in my application

  • +
    0 Votes

    hi

    manasachowdary6

    The string was not recognized as a valid DateTime. There is a unknown word starting at index 10.(this is my error but every thing in sp is correct and as well as in my application