Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
.NET equivalent of SELECT... WHERE NOT IN (select ...)
Message
 
À
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:
01620310
Vues:
53
>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
>
>TIA,
>
>Alex


http://stackoverflow.com/questions/183791/how-would-you-do-a-not-in-query-with-linq
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform