Using contains() in LINQ to SQL

by

Looking at the other attempts saddens me 🙁

public IQueryable<Part> SearchForParts(string[] query)
{
  var q = db.Parts.AsQueryable(); 

  foreach (var qs in query)
  { 
    var likestr = string.Format("%{0}%", qs);
    q = q.Where(x => SqlMethods.Like(x.partName, likestr));
  }

  return q;
}

Assumptions:

  • partName looks like: “ABC 123 XYZ”

  • query is { “ABC”, “123”, “XY” }

More Related Contents:

  1. Returning IEnumerable vs. IQueryable
  2. What is the syntax for an inner join in LINQ to SQL?
  3. Difference Between Select and SelectMany
  4. Random row from Linq to Sql
  5. How to check if a String contains any of some strings
  6. LINQ to SQL: Multiple joins ON multiple Columns. Is this possible?
  7. LINQ to SQL and a running total on ordered results
  8. Understanding .AsEnumerable() in LINQ to SQL
  9. How to compare only Date without Time in DateTime types in Linq to SQL with Entity Framework?
  10. LINQ Left Join And Right Join
  11. How to return anonymous type from c# method that uses LINQ to SQL [duplicate]
  12. Compare nullable types in Linq to Sql
  13. Updating an ObservableCollection in a separate thread
  14. Convert Linq Query Result to Dictionary
  15. .Contains() on a list of custom class objects
  16. Am I misunderstanding LINQ to SQL .AsEnumerable()?
  17. Persist Data by Programming Against Interface
  18. LINQ Where Ignore Accentuation and Case
  19. Get table-data from table-name in LINQ DataContext
  20. DISTINCT() and ORDERBY issue
  21. Linq query with nullable sum
  22. C# LINQ to SQL: Refactoring this Generic GetByID method
  23. LINQ to SQL using GROUP BY and COUNT(DISTINCT)
  24. How to make LINQ execute a (SQL) LIKE range search
  25. Will using LINQ to SQL help prevent SQL injection
  26. Best way to update LINQ to SQL classes after database schema change
  27. Last and LastOrDefault not supported
  28. Multiple/single instance of Linq to SQL DataContext
  29. Linq “Could not translate expression… into SQL and could not treat it as a local expression.”
  30. Accessing System Databases/Tables using LINQ to SQL?

Leave a Comment