Database Factory pattern with multiple databases
<p>I'm creating a database factory pattern for an application that should be able to work with SqlServer and Oracle. I've used a similar approach suggested in the following article: </p>

<p><a href="http://www.primaryobjects.com/CMS/Article81.aspx" rel="nofollow">http://www.primaryobjects.com/CMS/Article81.aspx</a></p>

<p>Now, the problem is that my application communicates with multiple databases on the same server. For ex: I'm running few queries against database DB1 and few queries against DB2, both on SqlServer. Using the above article, I could create an instance of one database. How can I use the same approach to work with multiple databases. Can somebody help me with this? Thanks.</p>
