Better structured LINQ request

Hi

I'm kinda new at the whole SQL thing... and as soon as I got into that I found myself moving to using LINQ expression pretty quickly (this is probably why I don't have the knowledge to answer my own question!).

I have a LINQ db request below:

 

Hiya,
I really enjoy LINQ and would love to dig into this with ya but my 6 arms are full right now.
This should help you a lot however, more than I just did.
http://msdn.microsoft.com/en-us/vcsharp/aa336746.aspx
Salute,
Mark

 

Try this:

 

Many thanks indeed Jamie - that worked a treat and enable me to remove the extensive dataset fudge that I'd had to build in.

It still feels a little like cheating so I will play a little more and post any progress I make... but for now the 'FirstOrDefault' trick works perfectly and is well worth knowing about.

Thanks again, Kurt

 

I love this kind of teamwork here.

 

OK so I have done some fiddling and came up with an approach that satisfies my aethestic as well as technical tastes. Here is the revised query: