CallRetrievalStoredProcedure question

Posts   
 
    
lsberman
User
Posts: 16
Joined: 22-Feb-2006
# Posted on: 05-Jun-2007 14:29:46   

Hi! How can I control the format of the value passed to the first parameter of the CallRetrievalStoredProcedure function, as shown below:

bool hasSucceeded = adapter.CallRetrievalStoredProcedure(
"[MyDb].[dbo].[DoSomething]", parameters, toReturn);

Right now when a retrieval procedure gets generated it includes the name of the database (i.e. MyDb) which I'd like to omit. This is important because I have several incarnations of the database that I need to work with (i.e. MyDb, MyDb_Dev, etc.)

BTW, If I manually remove "[MyDb]." and recompile everything wors fine.

jbb avatar
jbb
User
Posts: 267
Joined: 29-Nov-2005
# Posted on: 05-Jun-2007 15:15:03   

Hello,

what version of llbl do you use?

In the web.config file(or app.config file) you can add some keys :


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

that will allow llblgen to overrides the catalog name during the execution of the request.