Hi, I am using LLBLGen Pr02.0 version. I have a retrieval procedure which returns two resultsets. I couldn't access the second resultset using IDataReader. I am using TypedListDAO() to achieve this.

Is there a way to achieve this using TypedListDAO() not using "Projecting Dynamic List resultset onto custom classes" method.

Thanks in advance, Balaji

See documentation: "Projecting Stored Procedure resultset onto entity collection" in Using the generated classes -> Selfservicing -> Fetching datareaders and projections. hint: use reader.NextResult();

I have tried the option of dataReader.NextResult() method already, but I could not get the next resultset records in the dataReader object. Moreover I am taking the value to assign for my Third party tool Dundas Chart.

Is there any problem of using the CommandBehavior.CloseConnection property in the TypedListDAO.GetDataReader.

We need to fix this issue urgently to meet our client requirements. Kindly respond me immediately..

Many thanks, Balaji

Would you please post the code that you have been trying to use? And any exception/ error you receive with the corresponding stack trace. Thanks

Because of Commandcloseconnection gives the problem.I made it as CommandconnectionDefault. Its working fine.

Thanks for your supports

Balaji