ansaurus

Question

Select all NOT in requirement, Linq to SQL

Answer 1

+1 A:

If you want to select all Items you could do something like this.

var x = Items.Where(item => !Entries.Any(entry => entry.ItemID == item.ID && entry.ListID == listID));

Quintin Robinson 2009-09-11 20:47:05

Well, that just returns entries, not actual items.

Stacey 2009-09-11 20:49:48

Okay yeah I thought you might want the items, I added the example for that and will remove the first example.

Quintin Robinson 2009-09-11 20:50:44

Stacey 2009-09-11 20:53:38

Nevermind, I typed in the data wrong... I think this is exactly what I am looking for. I'm trying to read it closely to see if I understand what it is doing.

Stacey 2009-09-11 20:54:42

Sure, you are selecting from the Items table predicated on the fact that you only want items where there aren't any Entries matching an Item.ID where the Entry's ListID is the listID you are trying to exclude.

Quintin Robinson 2009-09-11 20:56:09

Answer 2

A:

var itemsToExclude = from dc.Lists in dc select l;

var x= from Entries in dc select e where !itemsToExclude.Contains(e.ListId)

Johannes Rudolph 2009-09-11 20:57:05

ansaurus

tags:

views:

answers:

Select all NOT in requirement, Linq to SQL

related questions