Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
.NET equivalent of SELECT... WHERE NOT IN (select ...)
Message
De
29/05/2015 03:07:52
 
 
À
28/05/2015 21:47:51
Information générale
Forum:
ASP.NET
Catégorie:
Entity Framework
Versions des environnements
Environment:
VB 9.0
OS:
Windows Server 2012
Network:
Windows 2008 Server
Database:
MS SQL Server
Application:
Web
Divers
Thread ID:
01620300
Message ID:
01620313
Vues:
47
>What is the equivalent in .NET LINQ of this VFP command?
>
>SELECT * ;
> FROM Cursor1 c1 ;
> WHERE c1.ID NOT IN (SELECT ID FROM Cursor2 c2) ;
> INTO Cursor c3

Top of my head and not tested:
var c3 = from x in c1 where ! (from y in c2 select y.ID).Contains(x.ID) select x;
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform