Linq To Entities: String.Contains a list

c# entity-framework-core linq pomelo-entityframeworkcore-mysql

Question

I am using ASP.net Core 3.0 with Entity Framework Core 3.0 and Pomelo.EntityFrameworkCore provider for MySQL, I need to query all the users that are from specific Towns. Lets say for example I have a list of strings called targettedTowns in which I have the following towns

var targettedTowns = new List<string>() {"korangi","landhi","zia colony","shah faisal","quaidabad"};
  • korangi
  • landhi
  • zia colony
  • shah faisal
  • quaidabad

Now I want to find all the users that are located in the targettedTowns list using Linq Lambda syntax.

Users in my database have their towns saved like

  • Korangi
  • Korangi-Zia Colony
  • Korangi-Bhittai Colony
  • Korangi-Allah Wala Town
  • Landhi-Sherpao
  • Landhi-Awami Colony
  • Landhi-Sherabad
  • ShahFaisal

What I am trying currently is

var users = context.Users.Where(x => x.Town.ToLower().Contains(targettedList)).ToList();

but as String.Contains does not take a list in argument so I cant use this.

1
0
3/29/2020 1:27:32 PM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Accepted Answer

You can try using Any method, I'm not sure whether it's supported but it's worth trying:

var result = context.Data.Where(data => searchTerms.Any(x => data.Name.Contains(x)) ||
                                        searchTerms.Any(x => data.Code.Contains(x));

If this gives you NotSupportedException you can add AsEnumerable before Where to fetch all records and execute the query in memory rather than DB.

13
12/4/2014 1:54:59 PM

Popular Answer

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

NinjaNye

Related Questions

Entity Framework List Contains in lambda

I want to query items with specific IDs using. For example:...var ids = new List<int> { 1, 3, 5 }; var items = context.Items.Where(item => ids.Contains(item.ID)).ToList(); ...Questions:...Will this generate a single query with SQL ...IN... operator?...Is this code OK in terms of performance?...Are there any better ways to do it?...I am using Entit...
.net c# entity-framework entity-framework-6 linq
asked by Andrei

EF how to update entity containing the List of entities

I have a class Device as follows....public class Device { public string id { get; set; } public string name { get; set; } public List<Instructions> Instructions { get; set; } } ...Now I have a view which has sections related to device and provision to add Instrunctions to the device. ...If the device is new then ...this.context.Devices....
asp.net-mvc asp.net-mvc-5.2 c# entity-framework entity-framework-6
asked by Learner

How to persist a list of strings with Entity Framework Core?

Let us suppose that we have one class which looks like the following:...public class Entity { public IList<string> SomeListOfValues { get; set; } // Other code } ...Now, suppose we want to persist this using EF Core Code First and that we are using a RDMBS like SQL Server....One possible approach is obviously to create a wraper class ...Wr...
.net-core c# entity-framework entity-framework-core
asked by user1620696

using linq to orderBy in list of lists

I have the following model:...public class Person { public int Id {get; set; } public string Name {get; set; } public List <Car> Cars {get; set; } } public class Car { public int Id {get; set; } public string Make {get; set; } public string Color {get; set; } } var persons = new List<Person>(){.....} ...I want to query the...
asp.net-mvc c# entity-framework-core linq
asked by capiono

Entity Framework String Size Limitation on Contains Clause

So, I have this lambda expression and it works just fine...list = list.Where(x => x.ListaDocumentoCaixa.Any(d => d.Observacao.Contains(term.Trim()))); ...I must add that this column is a ...varchar(6000)... field. So far, this has been working just fine as I mentioned, but just recently I've ran into an issue. It seems that if the term of the searc...
asp.net-mvc c# entity-framework entity-framework-6
asked by Raoni Medinilha

Forcing Case Insensitive String.Contains in Entity Framework Core

Is there any way to force LINQ to SQL to perform a case-insensitive Contains?...I'm working with PostgreSQL on Entity Framework Core.
.net c# case-insensitive entity-framework-core string
asked by SuperJMN

Create object containing a list using Dynamic Linq Core with Entity Framework 2.0

I have the following two classes:...public Part { public string PartNumber {get; set;} public string Description {get; set;} public List<Warehouse> Warehouses {get; set;} } public Warehouse { public string PartNumber {get; set;} public string WarehouseName {get; set;} public int Quantity {get; set;} public int ReorderPo...
c# dynamic-linq entity-framework-core list
asked by jpico

FromSql(): Query string building from string list to prevent injection

I'm building an SQL search in EF Core. Microsoft recommends you do not concat string because it leaves the application vulnerable to SQL injection as detailed in Microsoft Documentation: ...https://docs.microsoft.com/en-us/ef/core/querying/raw-sql.......Always use parameterization for raw SQL queries: In addition to validating user input, always ...
.net-core c# entity-framework-core sql-injection sql-server
asked by lloyd

What is the syntax for a LINQ filter for List<string>?

I have a C# program using EF Core....I fetch my records like this:...List<MyEntity> candidateRecords = await myFilters.ToListAsync(); ...I build my filters like this:...IQueryable<MyEntity> myFilters = from m in context.MyEntity select m; if (!string.IsNullOrEmpty(criterion1)) myFilters = myFilters.Where(s => s.S...
c# entity-framework-core linq
asked by FoggyDay

Select two lists as one list in ASP.NET Core linq

I am trying to create a query with ASP.NET Core EF Core and Linq that would give me a List of users based on two different lists, something like this:...return await _context.Users .Include(u => u.PropertyOwners) .ThenInclude(po => po.Property) .ThenInclude(p => p.PropertyTenantLeases) .In...
asp.net-core entity-framework-core linq
asked by bertilvandekerkhove

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge
View more on Stack Overflow

Prime Library

Performance

Expression Evaluator

More Projects...

Related

Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow