Hi,
I need a clarification regarding Database server independence. We are developing a portal application based on ASP.NET, WCF, SQLServer2005 and LLBLGenPro 2.5 version.
This portal application is accessed by our sales reps of multiple countries. For each and every country we are mainintaing a sepearte database with similar schema structure. Until now all the db's are hosted in a single server. So we are dynamically switching the database based on user profile without having any problem.
We are planning to host the databases on two different servers. How can i resolve or enforce multiple connection string issues by using only a single DAL layer.
Thanks in advance for your clarification.
Regards
Prabhu
