Stored Procedure call includes DB name
Joined: 08-Apr-2008
On our network, we haven't got a completely separate environment for development and testing - both environments share a common database server. Due to this, we have 2 databases with different names.
Using LLBLGen, if we make a call to a stored procedure, the generated SQL seems to be calling the stored procedure in the development database rather than the test database. We've traced this to the generated code and deleting the database name prefix and re-compiling gets everything working well again. Although a search-and-destroy using the IDE removed the database name prefix, sometimes developers forget to do it after regenerating the code using LLBLGen. 
The version we're using is LLBLGen Pro v2.5 Final (Sept 24th 2007).
Joined: 08-Apr-2008
Otis wrote:
Please check Catalog Name overwriting in the manual, section: Application configuration through config files (and I'd upgrade to the latest build of v2.5, as you're using a build which is quite old).
Hi!
I'm using the catalog name overwriting feature, which is why I'm able to do everything else - except calling stored procedures - without modifying the generated source code. Here's a code snippet:
/// <summary>
/// Calls stored procedure 'employersDelProc'.<br/><br/>
///
/// </summary>
/// <param name="id">Input parameter of stored procedure</param>
/// <param name="updatedById">Input parameter of stored procedure</param>
/// <param name="adapter">The DataAccessAdapter object to use for the call</param>
/// <returns>Amount of rows affected, if the database / routine doesn't surpress rowcounting.</returns>
public static int EmployersDelProc(System.Int32 id, System.Int32 updatedById, DataAccessAdapter adapter)
{
SqlParameter[] parameters = new SqlParameter[2];
parameters[0] = new SqlParameter("@id", SqlDbType.Int, 0, ParameterDirection.Input, true, 10, 0, "", DataRowVersion.Current, id);
parameters[1] = new SqlParameter("@updated_by_id", SqlDbType.Int, 0, ParameterDirection.Input, true, 10, 0, "", DataRowVersion.Current, updatedById);
int toReturn = adapter.CallActionStoredProcedure("[DoJo].[dbo].[employersDelProc]", parameters);
return toReturn;
}
I always have to take out the DB name prefix from the CallActionStoredProcedure method
BTW, by newer build, do you mean LLBLGen Pro v2.6?
-Nitin
Joined: 14-Dec-2003
