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").

~~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()
>