Linq to Entity Join table with multiple OR conditions

by

You don’t have to use the join syntax. Adding the predicates in a where clause has the same effect and you can add more conditions:

var query = (from RR in context.TableOne
             from M in context.TableTwo 
             where RR.OrderedProductId == M.ProductID
                   || RR.SoldProductId == M.ProductID // Your join
             where RR.CustomerID == CustomerID 
                   && statusIds.Any(x => x.Equals(RR.StatusID.Value))
             select RR.OrderId).ToArray();

More Related Contents:

  1. Dynamic where clause (OR) in Linq to Entities
  2. How to create LINQ Expression Tree to select an anonymous type
  3. ‘Contains()’ workaround using Linq to Entities?
  4. “A lambda expression with a statement body cannot be converted to an expression tree”
  5. Bulk-deleting in LINQ to Entities
  6. The type of one of the expressions in the join clause is incorrect in Entity Framework
  7. Entity framework left join
  8. LEFT JOIN in LINQ to entities?
  9. How to compare only date components from DateTime in EF?
  10. “The LINQ expression node type ‘Invoke’ is not supported in LINQ to Entities” – stumped!
  11. ‘Date’ is not supported in LINQ to Entities. Only initializers, entity members, and entity navigation properties are supported
  12. Dynamic query with OR conditions in Entity Framework
  13. Calling a SQL User-defined function in a LINQ query
  14. The LINQ expression node type ‘ArrayIndex’ is not supported in LINQ to Entities
  15. How do I apply OrderBy on an IQueryable using a string column name within a generic extension method?
  16. The cast to value type ‘Int32’ failed because the materialized value is null
  17. Value cannot be null. Parameter name: source
  18. The result of a query cannot be enumerated more than once
  19. Entity Framework. Delete all rows in table
  20. LINQ, Unable to create a constant value of type XXX. Only primitive types or enumeration types are supported in this context
  21. Export Model to DataTable
  22. Simulating Cross Context Joins–LINQ/C#
  23. Max return value if empty query
  24. Check if list contains item from other list in EntityFramework
  25. How to do an “in” query in entity framework?
  26. linq to entities vs linq to objects – are they the same?
  27. big issue in converting string to datetime using linq-to-entities
  28. Keep Getting ‘The LINQ expression node type ‘Invoke’ is not supported in LINQ to Entities’ Exception
  29. Should the order of LINQ query clauses affect Entity Framework performance?
  30. Is Injection Possible through Dynamic LINQ?

Leave a Comment