https://www.codetrigger.com/forum/topic30-change-db-connection-string-at-runtimedynamically.aspx CodeTrigger - General - Change db connection string at runtime/dynamically - Messages en-us http://blogs.law.harvard.edu/tech/rss Jitbit AspNetForum Mon, 04 Dec 2017 15:15:16 GMT Mon, 04 Dec 2017 15:15:16 GMT https://www.codetrigger.com/forum/topic30-change-db-connection-string-at-runtimedynamically.aspx Hi, there are some public properties that were created specifically for this purpose, i.e. changing the connectionstring at runtime.
Usage:
At an appropriate place in the code, you can override the connection string by setting it statically:

DATACONN0_TxConnectionProvider.ConnectionString = "Server=xxx;Port=xx;Initial Catalog=etc etc";
DATACONN0_BaseData.StaticConnectionString = "Server=xxx;Port=xx;Initial Catalog=etc etc";

both overrides would be necessary, one is just for queries (non-transactional) and the other provides transactional support.]]> Mon, 04 Dec 2017 15:15:16 GMT https://www.codetrigger.com/forum/topic30-change-db-connection-string-at-runtimedynamically.aspx What is the best way to set the connection string at run time, so the generated data and business objects point to a database specified by code. I need to use this in application where I can't specify the database in a app.config file, since it won't be accessible at runtime]]> Mon, 04 Dec 2017 15:13:07 GMT