Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

LINQ exclusion

Tags:

sql

linq

Is there a direct LINQ syntax for finding the members of set A that are absent from set B? In SQL I would write this

SELECT A.* FROM A LEFT JOIN B ON A.ID = B.ID WHERE B.ID IS NULL
like image 995
Peter Wone Avatar asked Dec 04 '22 16:12

Peter Wone


1 Answers

See the MSDN documentation on the Except operator.

like image 150
Quassnoi Avatar answered Dec 11 '22 15:12

Quassnoi