troubleshooting Question

C# Remoting Database Connection Management

Avatar of c0ry98
c0ry98 asked on
.NET Programming
3 Comments1 Solution801 ViewsLast Modified:
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
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 3 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 3 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros