How to specify dynamic field names in a Linq where clause?

by

You can build the Expression by hand, like so:

var eParam = Expression.Parameter(typeof(Employee), "e");

var comparison = Expression.Lambda(
    Expression.LessThan(
        Expression.Property(eParam, "Salary"),
        Expression.Constant(40000)),
    eParam);

return from e in db.Employee.Where(comparison)
       select new EmployeeViewModel { Name = e.name, Salary = e.Salary };

More Related Contents:

  1. Dynamic where clause (OR) in Linq to Entities
  2. Dynamic WHERE clause in LINQ
  3. Linq access property by variable
  4. How to read lines to dictionary with linQ [closed]
  5. Difference Between Select and SelectMany
  6. Distinct by property of class with LINQ [duplicate]
  7. Extension methods must be defined in a non-generic static class
  8. Dynamically access table in EF Core 2.0
  9. What’s the hardest or most misunderstood aspect of LINQ? [closed]
  10. C# – code to order by a property using the property name as a string [duplicate]
  11. LEFT JOIN in LINQ to entities?
  12. linq where list contains any in list
  13. Entity Framework (.NET Full Framework) Ordering Includes [duplicate]
  14. Get an IDataReader from a typed List
  15. LINQ Group By Multiple fields -Syntax help
  16. Entity Framework 6 Code First Custom Functions
  17. LINQ query to find if items in a list are contained in another list
  18. lambda expressions in immediate window for VS2015
  19. Merge multiple Lists into one List with LINQ
  20. Order by dynamic parameter
  21. convert this LINQ expression into Lambda
  22. List complex sorting
  23. Good way to get the key of the highest value of a Dictionary in C#
  24. How to sort a dictionary by key
  25. LINQ performance Count vs Where and Count
  26. Issues Doing a String Comparison in LINQ
  27. Select all columns after JOIN in LINQ
  28. How to include() nested child entity in linq
  29. Explicit/implicit cast operator fails when using LINQ’s .Cast() operator
  30. Convert DataTable to Generic List in C#

Leave a Comment