Two databases limit one connection to each
Posted by: Chris Bassett
Date: October 06, 2014 10:52AM

I have two separate databases that my .Net application needs to connect to (it's a Windows application, not a web app). It needs to be able to connect to both at the same time, so I'm looking for a way to limit the connection to each database to just one connection per database (thus preventing the application from opening a second connection to either of the databases).

I've played with the Singleton pattern, but that doesn't seem to work as i want it due to the nature of it only allows one connection at a time, regardless of how many databases you have. This could work, but I feel it would be more efficient to have one connection per databases, but no duplicate connections to either database.

Suggestions??

Options: ReplyQuote


Subject
Written By
Posted
Two databases limit one connection to each
October 06, 2014 10:52AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.