troubleshooting Question

C# Remoting Database Connection Management

Avatar of c0ry98
c0ry98 asked on
.NET Programming
3 Comments2 Solutions801 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
ASKER CERTIFIED SOLUTION
Die-Tech

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Log in to continue reading
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform for $9.99/mo
View membership options
Unlock 2 Answers and 3 Comments.
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
The Value of Experts Exchange in My Daily IT Life

Experts Exchange (EE) has become my company's go-to resource to get answers. I've used EE to make decisions, solve problems and even save customers. OutagesIO has been a challenging project and... Keep reading >>

Mike

Owner of Outages.IO
Phoenix, Arizona, United States
Member Since 2016
Join a full scale community that combines the best parts of other tools into one platform.
Unlock 2 Answers and 3 Comments.
View membership options
“All of life is about relationships, and EE has made a virtual community a real community. It lifts everyone's boat.”
William Peck

Member since 2004