Way to prevent database name string from being generated into sproc caller classes?

Posts   
 
    
Steve
User
Posts: 24
Joined: 20-Dec-2004
# Posted on: 10-Nov-2008 18:43:22   

Is there a way to prevent the database name string from being generated into the stored procedure calls in the StoredProcedureCallerClasses?

Generated code:

// Call the stored proc. DataTable toReturn = new DataTable("TablesList"); bool hasSucceeded = DbUtils.CallRetrievalStoredProcedure("[b][Northwind].[dbo].[/b][sproc_TablesList]", parameters, toReturn, null);

We need to remove the database name from the statement string, because we have a generic application that we run against multiple databases. We would like to only have to change the connection string value to be able to do this, but it won't work with the database name hardcoded in there.

VS 2008 SQL Server 2008 LLBLGen v.2.6 final 2.0/3.5 runtimes

daelmo avatar
daelmo
Support Team
Posts: 8245
Joined: 28-Nov-2005
# Posted on: 11-Nov-2008 04:06:37   

This should be helpful: http://llblgen.com/TinyForum/Messages.aspx?ThreadID=14407 Please read the "ref" link on that thread.

David Elizondo | LLBLGen Support Team