I have recently started to learn Dynamic Data Web application.
I have built a Dynamic data Website with LINQ data access layer. When the LINQ data context was built over an existing SQL2005 database, the connection string for that database was correctly, automatically, placed into the Settings and .edmx Code for the project. It works, but it's a "static" connection string.
I would like to be able to use this one LINQ data access layer against both test and production databases without having to manually change and recompile the project's connection string each time.
Is there a way to pass/change the User connection string to the LINQ data access layer at Run Time so that destination database changes? Ot in Other words How can user can choose a database from a list of databases.
View Complete Post