Link to home
Start Free TrialLog in
Avatar of c0ry98
c0ry98

asked on

C# Remoting Database Connection Management

Hi Experts,

I'm currently developing a C# Remoting application.  The application will be a windows service that basically connects to a couple databases and fields requests from the clients.  I am currently using SAO and singleton.

Requirements:
- I would like to establish a single connection to each database for all connections to use. (Connections take 1-2 seconds)
- Keep database connections open until the last client disconnects.

Currently I have the database connections open when the class is initialized (if the database connections aren't already open) and they remain open until the service restarts.  The issue is the connections never close and when the service has been idle for long enough the class opens a new database connection while the last database connection remains idle.  I don't want to close the database after each procedure call because that would defeat the purpose and I would be better off going with SingleCall.

How do I manage the database connection for a singleton remoting object? Is there an event that fires when the class is idle?

Thanks
ASKER CERTIFIED SOLUTION
Avatar of Die-Tech
Die-Tech

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of c0ry98
c0ry98

ASKER

Sorry for leaving this hanging.  I got side tracked with another project and a trip out of the country two weeks ago. I ended up switching to SingleCall since the application could be run stateless.  Thanks again for your help.