Hi. In the application we are building the connection string to the database will vary based on the project selected by the user from a dropdown. The schema of the database will be the same for each, but the database name and possibly the server can very based on this selection. Is there a recommended approach to dealing with this scenario within CSLA 4.0? At first glance it seems like a code mod to AdoHelper is in order (and to the template to avoid that getting overwritten), but I wanted to see if there is a better way. Any help is appreciated!
There should be overloads that allow you to specify your own connection string.
How you handle the list of databases/connectionstrings is entirely up to your application.
Thanks. I found a prior post from Rocky that helped me with this.
http://forums.lhotka.net/forums/p/9048/43015.aspx
This suggests to use the CSLA.ApplicationContext.ClientContext to keep track of the connection string. I modified the ADOHelper class to look to that collection for the proper connection string instead of the config file.
Copyright (c) Marimer LLC