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!!