Hi,
I am using llbngen Pro 3.1, SQL Server 2008 & Oracle 9i
I am Accessing Store Procedure using my own implementation as i have different number of parameters in sql and oracle store procedure.
When i used LLBLGen Pro to create code for accessing store procedure, it embedded connection string in code, do you know if i want to use connection string from web.config how i can use that?
here is the code:
private static StoredProcedureCall CreateEmpGeneralPkgGetEmpGeneralListCall(IDataAccessCore dataAccessProvider, System.Decimal pDomainId, System.String pSearch, System.Decimal pCount)
{
object pCursor = null;
object pCursor2 = null;
return new StoredProcedureCall(dataAccessProvider, "\"GRB_ASSIST_RBS4\".\"EMP_GENERAL_PKG.GET_EMP_GENERAL_LIST\"", "EmpGeneralPkgGetEmpGeneralList")
.AddParameter("P_DOMAIN_ID", "Decimal", 0, ParameterDirection.Input, true, 38, 38, pDomainId)
.AddParameter("P_SEARCH", "Varchar2", 4000, ParameterDirection.Input, true, 0, 0, pSearch)
.AddParameter("P_COUNT", "Decimal", 0, ParameterDirection.Input, true, 38, 38, pCount)
.AddParameter("P_CURSOR", "RefCursor", 0, ParameterDirection.Output, true, 0, 0, pCursor)
.AddParameter("P_CURSOR2", "RefCursor", 0, ParameterDirection.Output, true, 0, 0, pCursor2);
}
I wanted to use tablenamespace from web.config file
any idea?
