Avatar of nbbit

asked on 

From App.config in Startup Project, How do i propagate the ConnectionString to the data access layer?

I have several projects in one solution.  In one project lives all my datasets (DAL). They were developed using the dataset wizard and the connectionstring  is coming from Settings file for that project.

The Startup project contains the User Interface (UI).  I want to be able to control the database location (presumably from the application's App.config) file so that we can migrate easily from a test location to a live location and even (from the user.config file) a local data location for off-line use.

What is the best practice for, at run time, overriding the ConnectionString for the datasets in the DAL, since they currently come from their private settings ("My.settings")  namespace?
.NET ProgrammingMicrosoft Access

Avatar of undefined
Last Comment

8/22/2022 - Mon