Do untyped lists carry alot of overhead? Reason I ask is that I pasted the query that LLBL generates and I get back my results (100 records) in sub-second buy when I call DataAccessAdatper.FetchTypedList(), I do not get back a result for 10 seconds. Does this sound right?

Hmm...I changed the call to not allow duplicates and now it comes back instantly. I always though doing a distinct was more overhead...

Hi,

looking in the corresponding code, I could not find any reason for such a huge overhead just because of the AllowDuplicates flag.

Would you consider enabling the Trace to track the timing and post the generated queries?

Most likely the cause is that without a DISTINCT, a LOT of data is fetched (i.e. all duplicates), which causes a lot of rows. Entities are always fetched using a DISTINCT query (or if that's not possible, filtered out on the client)