ht998989

ht998989

  • NA
  • 3
  • 0

.Net Remoting Question

Oct 6 2003 3:33 AM
I would like to ask a question. I think that it is possible to make a class that is responsible for Database access that support Trans-SQL statements Stored Proc Returning DataSet/SqlDataReader when selecting data Number of rows affected when inserting/updating/deleting data with .Net Remoting. However, it is possible to make that class to support "Transaction" too? I found that if a "Transaction" is needed, the "Connection" is needed too. But all the things I want is not to allow the Client in having the Connection object, to seal the connection property from the Client, by providing the Database Name to the Remoted Class, and make the connection to each database access in the Remoted Class and does everything for the Client. As I'm using a SingleCall Server-Side Activated Remoted Class, each time the function call is finished, the connection will be lost. How can I provide the "Transaction" for the Client to use? Thanks for the help!!

Answers (1)