Greater Than Condition in Linq Join

by

You can’t do that with a LINQ joins – LINQ only supports equijoins. However, you can do this:

var query = from e in entity.M_Employee
            from p in entity.M_Position
            where e.PostionId >= p.PositionId
            select p;

Or a slightly alternative but equivalent approach:

var query = entity.M_Employee
                  .SelectMany(e => entity.M_Position
                                      .Where(p => e.PostionId >= p.PositionId));

More Related Contents:

  1. LINQ Join with Multiple Conditions in On Clause
  2. Simple Linq query has duplicated join against same table?
  3. If condition in LINQ Where clause
  4. Convert this sql command to c# linq
  5. LINQ equivalent of foreach for IEnumerable
  6. Is it possible to Pivot data using LINQ?
  7. What are the benefits of a Deferred Execution in LINQ?
  8. Why is LINQ JOIN so much faster than linking with WHERE?
  9. SQL to LINQ with multiple join, count and left join
  10. Entity framework linq query Include() multiple children entities
  11. How can I do an OrderBy with a dynamic string parameter?
  12. LINQ to Entities does not recognize the method ‘System.String Format(System.String, System.Object, System.Object)’
  13. Convert String to Int in EF 4.0
  14. System.LINQ.Dynamic: Select(” new (…)”) into a List (or any other enumerable collection of )
  15. LINQ: Dot Notation vs Query Expression
  16. Standard Deviation in LINQ
  17. How To Project a Line Number Into Linq Query Results
  18. Calculate difference from previous item with LINQ
  19. LINQ with SQLite (linqtosql)
  20. Entity Framework – “Unable to create a constant value of type ‘Closure type’…” error
  21. How to create a dynamic LINQ join extension method
  22. EF 4: Removing child object from collection does not delete it – why?
  23. Why use LINQ Join on a simple one-many relationship?
  24. Is there a pattern using Linq to dynamically create a filter?
  25. Select all columns after JOIN in LINQ
  26. OrderBy descending in Lambda expression?
  27. LINQ Include vs Join. Are they equivalent?
  28. Tradeoffs using NHibernate 3.0 QueryOver or LINQ provider
  29. LINQ: How to convert the nested hierarchical object to flatten object
  30. Fun (?) with Linq Expressions in extension methods

Leave a Comment