Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
.NET equivalent of SELECT... WHERE NOT IN (select ...)
Message
From
29/05/2015 03:07:52
 
 
To
28/05/2015 21:47:51
General information
Forum:
ASP.NET
Category:
Entity Framework
Environment versions
Environment:
VB 9.0
OS:
Windows Server 2012
Network:
Windows 2008 Server
Database:
MS SQL Server
Application:
Web
Miscellaneous
Thread ID:
01620300
Message ID:
01620313
Views:
46
>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;
Previous
Reply
Map
View

Click here to load this message in the networking platform