How can I conditionally apply a Linq operator?

by

if you want to only filter if certain criteria is passed, do something like this

var logs = from log in context.Logs
           select log;

if (filterBySeverity)
    logs = logs.Where(p => p.Severity == severity);

if (filterByUser)
    logs = logs.Where(p => p.User == user);

Doing so this way will allow your Expression tree to be exactly what you want. That way the SQL created will be exactly what you need and nothing less.

More Related Contents:

  1. Returning IEnumerable vs. IQueryable
  2. Difference Between Select and SelectMany
  3. Return anonymous type results?
  4. LINQ – Left Join, Group By, and Count
  5. When should I dispose of a data context
  6. How to do a subquery in LINQ?
  7. LINQ to SQL and a running total on ordered results
  8. Understanding .AsEnumerable() in LINQ to SQL
  9. How to return anonymous type from c# method that uses LINQ to SQL [duplicate]
  10. LINQ: combining join and group by
  11. Convert Linq Query Result to Dictionary
  12. Am I misunderstanding LINQ to SQL .AsEnumerable()?
  13. LINQ Where Ignore Accentuation and Case
  14. Get table-data from table-name in LINQ DataContext
  15. DISTINCT() and ORDERBY issue
  16. Linq query with nullable sum
  17. Custom Method in LINQ to SQL query
  18. LINQ to SQL using GROUP BY and COUNT(DISTINCT)
  19. Max or Default?
  20. How to make LINQ execute a (SQL) LIKE range search
  21. Will using LINQ to SQL help prevent SQL injection
  22. How do I do a left outer join with Dynamic Linq?
  23. Last and LastOrDefault not supported
  24. Linq “Could not translate expression… into SQL and could not treat it as a local expression.”
  25. Accessing System Databases/Tables using LINQ to SQL?
  26. LINQ to SQL Where Clause Optional Criteria
  27. Linq where column == (null reference) not the same as column == null
  28. Is Injection Possible through Dynamic LINQ?
  29. If Else in LINQ
  30. C# Linq to SQL: How to express “CONVERT([…] AS INT)”?

Leave a Comment