Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Comparism on two SQLs
Message
 
To
09/04/2012 09:58:56
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:
01540658
Views:
53
This message has been marked as a message which has helped to the initial question of the thread.
>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()
>
Not claiming to be a LINQ expert (I still think it's a PITA), but AFAIK they are the same.
____________________________________

Don't Tread on Me

Overthrow the federal government NOW!
____________________________________
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform