how to deactivate catalog info in the sql statememnt

Posts   
 
    
tommy
User
Posts: 5
Joined: 28-Feb-2007
# Posted on: 12-Apr-2007 10:37:04   

Hello Community,

i have one problem with llblgen in a compontent architcture. I have a vertical component who access to an database, but i don't know the name of the database. LLBLGen generate code who take the catalog info in the sql-statement eg

[mydatabase].[dbo].[myTable]

Is it possible to deactivate the catalog part in an generated sql statement.


I found a config-file- solution

<add key="CatalogNameUsageSetting" value="1"/> add key="CatalogNameToUse" value="MyProductionCatalog" />

Walaa avatar
Walaa
Support Team
Posts: 14995
Joined: 21-Aug-2005
# Posted on: 12-Apr-2007 11:30:55   

Also please check the manual: "Using the generated code -> Application configuration through .config files", for Catalog Name Overwriting.