Get everything except the SQL database using Entity Framework

Question

I have a list of products like this

var r = db.Products.Where(x => x.Sites .Where(z => z.Key == associatedProducts.Key) .Any() ).ToList() 

There is an object called "Products", I want to get all the elements from the products, except those that exist in related products. Products

How can i do this?

Answer 1

The following query works if a list of related products is retrieved using EF in the previos query.

 var temp = db.Products.ToList().Except(associatedProducts).ToList(); 

otherwise, if associatedProducts is a list that was not selected using EF (it is assumed that Key is an integer);

 List<int> tempIdList = associatedProducts.Select(q => q.Key ).ToList(); var temp = db.Products.Where(q => !tempIdList.Contains(q.Key)); 

Answer 2

  var query = from p in db.Products where !(from a in associatedProducts.Products select a.Products) .Contains(p.Key) select p; 

I have not tested the request, but it should look like this.

You should see how you can use "not in" in linq:
How would you make a "not in" query with LINQ?

Answer 3

You can download the list of products that you want to exclude, and then .Exclude() from the list of all products.