>>>Narrow down all that to a simple SELECT and then return either an ADO.Net record set or an EF entity.
>>>
>>
>>I found some samples using DataTable and also apparently we have methods that operate with the datatable, so I am going to proceed this route.
>
>You could probably write this in t sql while you were reading the paper in the morning. Why mess with C# / ADO. Just munge the data on the back end an return the product (or, for that matter, return XML)

After moving this into T-SQL it now executes twice as fast.