score:2

Accepted answer

The sequence contains the id and not the other way around, this is what the error is stating. You should swap these:

!(from clcl in bitDB.component_labels_change_lists 
  select clcl.change_list_id).Contains(cl.change_list_id)

You can also try:

!bitDB.component_labels_change_lists.Any(clcl => clcl.change_list_id == cl.change_list_id)

But Check the generated queries and choose whatever is faster (This might help on this one: https://stackoverflow.com/a/1412902/3185569)


Related Query

More Query from same tag