score:0
string[] stringstosearchfor = new string[] { "text1", "text2" };
using (mydbcontext model = new mydbcontext())
{
var result = model.atable
.where(r => stringstosearchfor.any(s => r.name.contains(s)))
.tolist();
}
score:2
.where(x => stringstosearchfor.any(s => dbfunctions.like(x.name, "%" + s + "%")))
Source: stackoverflow.com
Related Query
- Searching for multiple strings using single database query with entity framework and LINQ
- Deleting multiple records with Entity Framework using a single LINQ query
- Searching for text in a database with Entity Framework
- LINQ query help: searching for data in a Many to Many using Entity Framework
- How to select a query with multiple columns and put it into variables using Entity Framework and ASP.NET?
- Is there a way to show a single employee with each of his projects using a query in Entity Framework
- Entity Framework EF Query using LINQ for related Entities - Getting Customers with their orders from specific period of time only
- Query Using Entity Framework Error with Database Table name Error
- Using a enum with flag in an Entity Framework query
- Common query for multiple similar entity types in Entity Framework
- Dynamic linq query expression tree for sql IN clause using Entity framework
- Retrieve single Entity Framework entities using a LINQ query or GetObjectKey?
- Entity Framework with Oracle using odp.net not taking parameters in linq query
- Entity Framework Core LINQ query with multiple where clauses
- Query Xml from SQL using Entity Framework Database First
- How to query many-to-many relationship with 'AND' condition using LINQ and Entity Framework
- Proper Searching with Linq, Entity Framework and Database Indexes
- How to get Multiple Result Set in Entity Framework using Linq with C#?
- Update Database using Entity Framework having primary key on multiple Columns
- Join multiple tables and single output using Entity Framework mvc5
- Does Entity Framework query the database multiple times if I use different fields of the same Linq query at different times?
- Pull data from multiple tables in one SQL query using LINQ and Entity Framework (Core)
- Exception raised when using a Linq query with Entity Framework
- How can I query using Entity Framework with an alpha-numeric comparison?
- Using Linq to query Entity Framework with Where clause and many-to-many relation
- Linq query with many to many relations using entity framework
- LIKE query with underscore (_) using Entity Framework & Sqlite
- Which LINQ statement is efficient for searching record using entity framework
- Searching Record List using single parameter Id and compare with multiple columns EF
- How to write Linq Queries for CRUD operations using Entity Framework with Asp.Net?
More Query from same tag
- LINQ get elements from one collection that don't belong to another
- ASP.NET MVC - Join Tables using LINQ
- Does LINQ's ExecuteCommand provide protection from SQL injection attacks?
- using group by in linq nested list c#
- How to Avoid changing orders in linq sequence concat
- LINQ to Entities does not recognize the method 'Int32 ToInt32(System.Object)' method
- Sql Server Query Visualizer – Cannot see generated SQL Query
- SELECT result map to entity in Dynamic Linq in Entity Framework Core
- Retrieve index in LinQ Lambda Join
- What's Include() method's job in Entity Framework
- Linq error while dragging and dropping my table from server explorer to dbml file
- Linq query to get distinct object based on date and priority
- Filtering List from a List
- Entity framework with Linq
- How to find the top number between a range given a value from a table using LINQ
- List<string> complex sorting
- Can't I use two different condition at "on" in a join?
- C# LINQ value substitution
- LINQ query not returning desired result as string. Why?
- Reduce linq query for filtering
- Get items from list where inner list contains set of enum-values
- Kendo MVC Dynamic Linq extensions
- How to trim in Linq to SQL?
- Exclude some items from a list with Lambda
- Average int Array elements with a GroupBy
- LINQ merge a collection
- Using lambda expressions on joined basic LINQ query
- Can I use LINQ to get all kinds of control present in my form?
- Wrap text in xml into element tags in Linq to Xml
- Linq: Method that returns first instance with given type