How do you check if a string contains any strings from a list in Entity Framework?

by

I’m late to the party but using the SearchExtensions nuget package you could do something like the following

var result = context.Data.Search(x => x.Name, x => x.Code).Containing(searchTerms);

This builds an expression tree so will still perform the query on the server (and not in memory) and will essentially run the SQL you desire above

More Related Contents:

  1. summing values of a column based on id [closed]
  2. There is already an open DataReader associated with this Command which must be closed first
  3. MSSQL Error ‘The underlying provider failed on Open’
  4. Why does the EF 6 tutorial use asynchronous calls?
  5. Method cannot be translated into a store expression
  6. composite key as foreign key
  7. Implementing Zero Or One to Zero Or One relationship in EF Code first by Fluent API
  8. How can I log the generated SQL from DbContext.SaveChanges() in my Program? [duplicate]
  9. LINQ to Entities only supports casting EDM primitive or enumeration types with IEntity interface
  10. One to one optional relationship using Entity Framework Fluent API
  11. How to compare only Date without Time in DateTime types in Linq to SQL with Entity Framework?
  12. Implementing Audit Log / Change History with MVC & Entity Framework
  13. Filter all queries (trying to achieve soft delete)
  14. Entity Framework – Cannot convert lambda expression to type ‘string’ because it is not a delegate type
  15. Internal .NET Framework Data Provider error 1025
  16. Can EF automatically delete data that is orphaned, where the parent is not deleted?
  17. How to filter data using Entity Framework in a way that DataGridView be editable and context track changes?
  18. How to I apply filter while paginating in Asp.net MVC and entity Framework?
  19. Global setting for AsNoTracking()?
  20. EF5 Getting this error message: Model compatibility cannot be checked because the database does not contain model metadata
  21. Json.Net adding $id to EF objects despite setting PreserveReferencesHandling to “None”
  22. Remove item from list based on condition
  23. Async PartialView causes “HttpServerUtility.Execute blocked…” exception
  24. Unit testing with EF Core and in memory database
  25. Entity Framework Eager Load Not Returning Data, Lazy Load Does
  26. EF models. Navigation properties can only participate in a single relationship
  27. Seed Entities AND Users, Roles?
  28. How to include() nested child entity in linq
  29. Oracle Entity Framework – Generate Entity From Tables in Different Schema
  30. Entity framework – get entity by name

Leave a Comment