Hello,

I was tasked with switching the database of an older .Net project that incorporates LLBLGen Pro 4.2 to Microsoft Azure SQL. Sadly, there's noone left who has any knowledge of LLBLGen and no resources are available to change that. Entities are generated via a custom .Net project that uses LLBLGen - the code of that project isn't available anymore.

Is there any easy way to turn of catalog name generation in LLBLGen Pro 4.2 so that a connect to MS Azure SQL would word and if so, where do I have to set it up?

Thanks in advance!

Regards, DK

Use catalog name overwriting in the config file of your app:

https://www.llblgen.com/Documentation/4.2/LLBLGen%20Pro%20RTF/hh_goto.htm#Using%20the%20generated%20code/gencode_applicationconfiguration.htm#catalognameoverwriting

set the destination name to "" and you shouldn't get the name in the queries See: https://www.llblgen.com/Documentation/4.2/LLBLGen%20Pro%20RTF/hh_goto.htm#Using%20the%20generated%20code/gencode_dbspecificfeatures.htm#SQLAzure

Otis wrote:

Use catalog name overwriting in the config file of your app:

https://www.llblgen.com/Documentation/4.2/LLBLGen%20Pro%20RTF/hh_goto.htm#Using%20the%20generated%20code/gencode_applicationconfiguration.htm#catalognameoverwriting

set the destination name to "" and you shouldn't get the name in the queries See: https://www.llblgen.com/Documentation/4.2/LLBLGen%20Pro%20RTF/hh_goto.htm#Using%20the%20generated%20code/gencode_dbspecificfeatures.htm#SQLAzure

Good to hear we don't necessarily have to upgrade LLBLGen. Our implementation utilizes the CliRefresher.exe / CliGenerator.exe, do I have to set those settings in their respective .config files? I've tried it right at the beginning (initial tag after the <configuration> tag) in both configs, like:

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

Didn't seem to do anything...

These configuration settings are used in your application along with the generated code.

The CliRefresher uses whatever connectionString stored in the llblgen project file.

Are you doing modifications in that old project, or you just want to move the production database to Azure SQL?