Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
.NET equivalent of SELECT... WHERE NOT IN (select ...)
Message
 
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:
01620310
Views:
52
>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.
Previous
Reply
Map
View

Click here to load this message in the networking platform