Hello,
I have this relation:
Customer - Order - Product each mapped to its own sql table.
When I want to eager load now the Customers with its Orders and the Orders with its Products
How do I have to iterate the 3 sqldatareader to get in the end a IEnumerable just as
I would use an ORM.
What I do not want to do is to pass the SqlDataReader to the constructor of my business models.
I would be pleased about a best practice approach or maybe there exist a design pattern ?