Unable to create a constant value – only primitive types

by

First way :

Remove ToList() in the first query.

Or

//instead of retrieving mathings List, retrieve only the productIds you need (which are a List of Primitive types)
var productIdList = db.matchings
.Where(m => m.StoreId == StoreId)
.Select(x => x.ProductId)
.ToList();

var products = db.Products
.Where(p => productIdList
           .Contains(p.ProductId))
.ToList();

Or

//other way
var produts = db.Products
             .Where(p => db.matchings
                        .Any(m => m.StoreId == StoreId && 
                             m.ProductId == p.ProductId)
                    )
             .ToList();

Because I think you’re in linq2entities, and you’re using a List of Matchings in a query which is not possible (the title of your topic tend to make me believe that’s your problem).

More Related Contents:

  1. How to display words that appear more than 'x' times in a text? [closed]
  2. linq syntax: What is the type that this returns? How can I now go ahead and use firstRow.ingredientName etc?
  3. Retrieving Property name from lambda expression
  4. How do I apply OrderBy on an IQueryable using a string column name within a generic extension method?
  5. How do I specify the Linq OrderBy argument dynamically? [duplicate]
  6. When to use BlockingCollection and when ConcurrentBag instead of List?
  7. How to get the index of an element in an IEnumerable?
  8. How do I invoke an extension method using reflection?
  9. Entity framework left join
  10. Use LINQ to group a sequence of numbers with no gaps
  11. Find index of a value in an array
  12. LINQ: combining join and group by
  13. How do you add an index field to Linq results
  14. Add two Lists of different length in C#
  15. Number of occurrences of a character in a string [duplicate]
  16. Local sequence cannot be used in LINQ to SQL implementation of query operators except the Contains() operator
  17. Linq query built in foreach loop always takes parameter value from last iteration
  18. Entity Framework. Delete all rows in table
  19. “The LINQ expression node type ‘Invoke’ is not supported in LINQ to Entities” – stumped!
  20. Rotate – Transposing a List using LINQ C#
  21. Find() vs. Where().FirstOrDefault()
  22. How to Get XML Node from XDocument
  23. Cannot implicitly convert type ‘System.Collections.Generic.IEnumerable’ to ‘System.Collections.Generic.List
  24. Is there an IEnumerable implementation that only iterates over it’s source (e.g. LINQ) once?
  25. How to create LINQ Query from string?
  26. LINQ .Any VS .Exists – What’s the difference?
  27. Simulating Cross Context Joins–LINQ/C#
  28. How to do an “in” query in entity framework?
  29. LINQ: Add RowNumber Column
  30. Is there an easy way to merge two ordered sequences using LINQ?

Leave a Comment