Hi, I am using LLBLGEN Pro2.0 version in my web application & SQL Server 2005 as basckend. I have a retrieval stored procedure which returns the data. I need to get the data as datareader object through LLBLGen Pro.

How can i acheive this?

Thanks in advance, Balaji

Using the Designer, you shouldn't have problem including your stored procedures in the generated code.

For reference, in adapter scenario, it will go into the RetrievalProcedures class from the DBSpecific project.

Then have a look at the section "Generated code - Fetching DataReaders and projections, Adapter" from the manual, which tells you how to retrieve DataReaders instead of the native DataTable