Maybe the Where method provides the Select syntax?

>>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
>
>
>
>>
>>
>>
>>>I need to know if those two SQLs are equal. Basically, the only different is the Select s in the second one.
>>>
>>>

>>>                oClient = (From s
>>>                 In oClientAPI.GetClientForSpecific()
>>>                 Where s.ClientId = nClientID).FirstOrDefault()
>>>

>>>
>>>

>>>                oClient = (From s
>>>                 In oClient.GetClientForSpecific()
>>>                 Where s.ClientId = nClientID
>>>                 Select s).FirstOrDefault()
>>>