> I have a performance query regarding LINQ that I would like some opinions.
>
[quoted text clipped - 14 lines]
> or is there another way of achieveing the same speed of lookup via LINQ
> functionality?
A call to ToDictionary would seem the obvious choice, specifying a
lambda expression which pulls out the GUID as the key.

Signature
Jon Skeet - <skeet@pobox.com>
http://www.pobox.com/~skeet Blog: http://www.msmvps.com/jon.skeet
World class .NET training in the UK: http://iterativetraining.co.uk
Jake McCool - 18 Mar 2008 11:31 GMT
Thanks Jon,
do you know what the performance implications would be by comparison to a
DataReader?
>> I have a performance query regarding LINQ that I would like some
>> opinions.
[quoted text clipped - 20 lines]
> A call to ToDictionary would seem the obvious choice, specifying a
> lambda expression which pulls out the GUID as the key.
Jon Skeet [C# MVP] - 18 Mar 2008 11:38 GMT
> do you know what the performance implications would be by comparison to a
> DataReader?
Unlikely to be significant, particularly if you use compiled queries.
However, the best way to find out is to try it and measure.

Signature
Jon Skeet - <skeet@pobox.com>
http://www.pobox.com/~skeet Blog: http://www.msmvps.com/jon.skeet
World class .NET training in the UK: http://iterativetraining.co.uk