Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Comparism on two SQLs
Message
 
À
09/04/2012 09:58:56
Information générale
Forum:
ASP.NET
Catégorie:
LINQ
Versions des environnements
Environment:
VB 9.0
OS:
Windows 7
Network:
Windows 2003 Server
Database:
MS SQL Server
Application:
Web
Divers
Thread ID:
01540656
Message ID:
01540658
Vues:
54
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!
____________________________________
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform