Hi,

I am using VS2010, WCF 3.0, LLBnGen 3.1, Oracle 11i & SQL 2008.

I am trying to access data from through web service and i am getting following exception in DataAccessAdapter.cs (SQL Server specific). There is not much detail in exception which can help, i have attached screenshot for your reference. This error is occurred when i am trying to access store procedure, and i am using my own implementation for SP, as i have different no of parameters in sql and oracle. Same test is working in my web application but i have problem only with store procedure in web service. I was not able to run orm profiler also.

FYI,

I have created factory adapter class to pass correct dataaccess adapter to datalayer which might be problem? But this is working in web application.

Adapter class method:

static public SD.LLBLGen.Pro.ORMSupportClasses.IDataAccessAdapter GetDataAccessAdapter(string connectionstring,string providerName) {

       if (string.Equals(providerName, SqlServerProviderInvariantName, StringComparison.InvariantCultureIgnoreCase))
  {
    return new Grb.Framework.Business.Lower.SqlServer.DatabaseSpecific.DataAccessAdapter(connectionstring);
  }
  else if (string.Equals(providerName, OracleProviderInvariantName, StringComparison.InvariantCultureIgnoreCase))
  {
    return new Grb.Framework.Business.Lower.Oracle.DatabaseSpecific.DataAccessAdapter(connectionstring);
  }

  return null;

}

}

Any Idea?

It could be something about how you use your custom factory. Maybe there are recursion somewhere. Please post the exact exception message and stack trace. You also could analyze the call hierarchy with VSNet or another memory profiler to see where is a potential overflow.