<p>Is there a way to change the connection string of a DataBase object in Enterprise Library at runtime? I've found <a href="http://blog.benday.com/archive/2005/05/05/357.aspx" rel="nofollow noreferrer">this</a> link but its a little bit outdated (2005)</p>

<p>I've also found <a href="https://stackoverflow.com/questions/63546/vs2005-c-programmatically-change-connection-string-contained-in-appconfig">this</a> but it seems to apply to .Net in general, I was wondering if there was something that could be done specifically for EntLib.</p>

<p>I was just passing the connection string name to the CreateDatabase() method in DatabaseFactory object and that worked til yesterday that my project manager asked me to support more than one database instance. It happens that we have to have one database per state (one for CA, one for FL, etc...) so my software needs to cycle through all databases and do something with data but it will use the same config file.</p>

<p>Thanks in advance.</p>

If you take a look at "
Enterprise Library Docs - Adding Application Code
"
 it says this:
"If you know the connection string for
  the database you want to create, you
  can bypass the application's
  configuration information and use a
  constructor to directly create the
  Database object. Because the Database
  class is an abstract base class, you
  must construct one of its derived
  types. The derived Database type
  determines the ADO.NET data provider.
  For example, the SqlDatabase class
  uses the SqlClientFactory provider,
  the SqlCeDatabase class uses the
  SqlCeProviderFactory provider, and the
  OracleDatabase class uses the
  OracleClientFactory provider. It is
  your responsibility to construct the
  appropriate type of Database class for
  the connection string."
It then goes on to give some examples. This would suggest that you should not be using the DatabaseFactory and you should be creating a new Database class for each of your different connections.