Linq to SQL and Intersect

Question

Folks,

I need to use Intersect on a LINQ to SQL query. However, I get an exception basically stating that I can't.

The code compiles fine, but LINQ to SQL gets angry.

Is there any way to replicate Intersect with LINQ to SQL?

Thanks in advance.

Sorry, I wrote this question up in WAY too much of a hurry. I'll get the exact exception later. I saw you article down below, and it sure does look like I should be able to use Intersect...weird. — CubanX, Oct 14 '10 at 23:38
It is definitely possible. See this example: http://msdn.microsoft.com/en-us/library/bb399392.aspx — Adrian Grigore, Oct 14 '10 at 21:23

score 2 · Answer 1 · answered Oct 14 '10 at 21:28

2

Here is an example of how to do this:

var coolColors = (from pen in mydb.Pens select pen.Color).Intersect
        (from pencil in mydb.Pencils select pencil.Color);

answered Oct 14 '10 at 21:28

Michael Goldshteyn

71,784
24
131
181

score 0 · Answer 2 · answered Jun 13 '22 at 12:52

0

var example = memoryObject.Union(sqlObject)is not allowed but you can do var example = sqlOjbect.Union(memoryObject) if both sqlObject and memoryObject are of the same type.

answered Jun 13 '22 at 12:52

fantagons

9
3

Linq to SQL and Intersect

2 Answers2

Linked