Is there a way to specify using multiple catalogs in code for self-servicing?

The relevant section in the documentation reads:

Multi-tenancy support is implemented through catalog/schema name overwriting at runtime. This is configurable through code and by definitions in the .config file of your application

What follows describes how to set the .config file.

Could you please elucidate how/if this can be done purely in code?

Thanks

David

P.S. I am using LLBLGEN Pro 3.5 Final May 31, 2012.

SelfServicing doesn't support per-call name overwriting, as there's no 'known connection' at any given point. You can only overwrite, in code, globally in selfservicing, which means it's affecting all connections. If you want per-call name overwriting, use adapter, as described in the template group descriptions in the documentation.

Hi Otis,

Good to hear from you.

Indeed, I know that Adapter is required for per-cell overriding.

In the self-servicing application the database is selected for the entire session -- so it is static.

I implemented this using the suggested change in the configuration, where Kamino is the name of the original database.

    <configSections>
        <section name="sqlServerCatalogNameOverwrites" type="System.Configuration.NameValueSectionHandler" />
    </configSections>
    <sqlServerCatalogNameOverwrites>
        <add key="Kamino" value="" />
    </sqlServerCatalogNameOverwrites>

My question is: can this be done in code instead of in .config.

Thanks

David

What you have in the config file neutralizes the caalog name, so it will depend on the catalog name in the connectionString used. Which canbe globally set by using the following:

CommonDaoBase.ActualConnectionString = "....";