Hi,

I'm using LLBLGen Pro V2.0 in my application. I had created a complex stored procedure which will return 2 result sets. The resultsets are the combinations of more than five tables.

Using "Projecting Dynamic List result set onto custom classes", we can return more than 1 result sets. Also, to create a dynamic list, we are using scalar sub queries. But in my case, I'm using complex logic and deriving those 2 result sets with different fields from more than five tables.

My question is

How to achieve this by "Projecting Dynamic List result set onto custom classes" for my complex stored procedure returning 2 result sets as datareader object?

Regards, Balaji

Create a class that has properties representing each field from each result set. It does not matter where those results sets came from or if you just made them up. You then project them onto those custom classes.

So, if the first resultset contains fields of "FirstName", "Unit", "Shipped" - then created a class that has those properties - and project onto that custom class.