Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Comparism on two SQLs
Message
From
13/04/2012 09:51:04
 
General information
Forum:
ASP.NET
Category:
LINQ
Environment versions
Environment:
VB 9.0
OS:
Windows 7
Network:
Windows 2003 Server
Database:
MS SQL Server
Application:
Web
Miscellaneous
Thread ID:
01540656
Message ID:
01541396
Views:
27
>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
Bonnie Berent DeWitt
NET/C# MVP since 2003

http://geek-goddess-bonnie.blogspot.com
Previous
Reply
Map
View

Click here to load this message in the networking platform