c# - Handling multiple connection strings in ONE DataAccess Layer -
I have an interesting dilemma I currently have a dataweek layer that will work with multiple domains and in those domains Based on the procedures stored in each one, there are many database treasures as AS, I'm just running on the application to determine the machine to use a SWITCH statement and return the proper connection string to Web.config is. Now I have a daunting task in dealing with multiple database treasures in the same SQL Server and IDs, such as dynamically determining the connection string based on the stored procedure. Maybe I am thinking on this, but I am not able to wrap my head about how to handle it. First of all I can say that there is a flaw in your design, because multiple databases have multiple stored processes Inviting is unusual. However, many options are available, because example: Web. Store a list of stored procedures with each of the corresponding connection strings in the config and retrieve them at runtime. Collect a centralized table e...