>Maybe the Where method provides the Select syntax?According to Craig in Message #
1540681, VB has some helper methods for the query syntax that C# doesn't. I'm guessing the lambda query doesn't need them.
~~Bonnie
>
>>
>There must be a difference between VB's implementation of LINQ and C#'s implementation, because in C# I can't even write the first query without getting a compiler syntax error ("A query body must end with a select clause or a group clause").>>
>>However, if I write the query using a lambda expression, I don't get the syntax error and it works:
>>
>>Syntax error:
>>
>>var query1 = (from person in dsPers.Personnel
>> where person.firstname == "Fred").FirstOrDefault();
>>
>>No syntax error and it works:
>>
>>var query3 = dsPers.Personnel.Where(person=>person.firstname == "Fred").FirstOrDefault();
>>
>>
>>Strange ...
>>
>>~~Bonnie