You should use CatalogName Overwrites section in the config file, with an empty new catalog name.
eg.
<configSections>
<section name="sqlServerCatalogNameOverwrites" type="System.Configuration.NameValueSectionHandler" />
</configSections>
<sqlServerCatalogNameOverwrites>
<add key="myDevCatalog" value="" />
</sqlServerCatalogNameOverwrites>
-
This will force the system to use the catalog name in the connection string.
-
And hence you may pass the connection string to the DataAccessAdapter CTor.
(Which might differ based on the logged in user).
eg:
using (DataAccessAdapter adapter = new DataAccessAdapter(theConnectionStrWithUser1))
{
...
}
...
using (DataAccessAdapter adapter = new DataAccessAdapter(theConnectionStrWithUser2))
{
...
}