Compare two instances of IQueryable

Question

I have two instances IQueryable- objIQuerableAand objIQueryableB, and I want to get only those elements that are present in objIQuerableA, not in objIQuerableB.

One way is to use a foreach loop, but I'm wondering if there is a better method.

Answer 1

Simple and direct.

var result = objIQuerableA.Except(objIQuerableB);

Answer 2

The title says a comparison of two IQueryables. If you want to actually do a comparison to determine if both IQueryables contain the same results in the same query ....

var aExceptB = objIQuerableA.Except(objIQuerableB);
var bExceptA = objIQuerableB.Except(objIQuerableA);
var symmetricDiff = aExceptB.Union(bExceptA);
bool areDifferent = symmetricDiff.Any();