Class Library Dynamics For Connectstring Information
Greetings:
I created a class library using VB.NET for use in ASP.NET web applications. The class library is a project in Visual Studio 2015 Pro.
Since the class library contains dataset files (.xsd) which requires a connectstring to, in my case, a Microsoft SQL database.
I use this class library in several client ASP.NET web applications. The connectstring points to a different SQL database for each client.
Is there a way at run time I can supply the connectring information for a specific client SQL database? Currently the app.config file is storing connectstring values for the last client I worked on.
Much thanks for any information you can share!
David Bach
I created a class library using VB.NET for use in ASP.NET web applications. The class library is a project in Visual Studio 2015 Pro.
Since the class library contains dataset files (.xsd) which requires a connectstring to, in my case, a Microsoft SQL database.
I use this class library in several client ASP.NET web applications. The connectstring points to a different SQL database for each client.
Is there a way at run time I can supply the connectring information for a specific client SQL database? Currently the app.config file is storing connectstring values for the last client I worked on.
Much thanks for any information you can share!
David Bach
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I apologize for the delay.
Thank you for your expert advice. I took part of your solution and created default connection strings which I subsequently overrode with the actual connection strings.
I would not have thought of this without your words of wisdom.
Again, much thanks ... David