Creating dynamic queries with entity framework

by

You could compose an IQueryable<T> step by step. Assuming you have a FilterDefinition class which describes how the user wants to filter …

public class FilterDefinition
{
    public bool FilterByName { get; set; }
    public string NameFrom { get; set; }
    public string NameTo { get; set; }

    public bool FilterByQuantity { get; set; }
    public double QuantityFrom { get; set; }
    public double QuantityTo { get; set; }
}

… then you could build a query like so:

public IQueryable<SomeEntity> GetQuery(FilterDefinition filter)
{
    IQueryable<SomeEntity> query = context.Set<SomeEntity>();
    // assuming that you return all records when nothing is specified in the filter

    if (filter.FilterByName)
        query = query.Where(t => 
            t.Name >= filter.NameFrom && t.Name <= filter.NameTo);

    if (filter.FilterByQuantity)
        query = query.Where(t => 
            t.Quantity >= filter.QuantityFrom && t.Quantity <= filter.QuantityTo);

    return query;
}

More Related Contents:

  1. Entity Framework/Linq EXpression converting from string to int
  2. LEFT JOIN in LINQ to entities?
  3. The result of a query cannot be enumerated more than once
  4. How to create LINQ Expression Tree to select an anonymous type
  5. Unable to create a constant value of type Only primitive types or enumeration types are supported in this context
  6. Entity Framework Timeouts
  7. “A lambda expression with a statement body cannot be converted to an expression tree”
  8. Why is .Contains slow? Most efficient way to get multiple entities by primary key?
  9. Establish a link between two lists in linq to entities where clause
  10. A specified Include path is not valid. The EntityType does not declare a navigation property with the name *
  11. Error: “The specified LINQ expression contains references to queries that are associated with different contexts”
  12. LINQ to Entities does not recognize the method ‘Int32 Int32(System.String)’ method, and this method cannot be translated into a store expression
  13. Entity Framework Code First Lazy Loading
  14. How to group by on 2 child entities and get total of both this child entities?
  15. How to convert an expression tree to a partial SQL query?
  16. Generate EF orderby expression by string [duplicate]
  17. Internal .NET Framework Data Provider error 1025
  18. Entity Framework Include() is not working
  19. How does LINQ expression syntax work with Include() for eager loading
  20. Filtering include items in LINQ and Entity Framework [duplicate]
  21. Better way to query a page of data and get total count in entity framework 4.1?
  22. Entity Framework Code Only error: the model backing the context has changed since the database was created
  23. The LINQ expression could not be translated and will be evaluated locally
  24. Update records using LINQ
  25. Calling a SQL User-defined function in a LINQ query
  26. Remove item from list based on condition
  27. Change db table name in EF4 (entity framework 4)
  28. How to include() nested child entity in linq
  29. Entity Framework Code First naming conventions – back to plural table names?
  30. Should the order of LINQ query clauses affect Entity Framework performance?

Leave a Comment