EF.Functions.Contains including multiple keywords

asp.net-core entity-framework-core linq

Question

I need to search on multiple columns (LearningModuleDesc and LearningModuleContent which works using the || statements below) but I also need to search on multiple keywords. .Net Core 2.2 and EF Core does not support the string array with Contains (like the example below) but some guidance of how I would go about this would be great. 

string[] stringarray = new string[] { "mill", "smith" };

var results =  _context.LearningModules
.Where(x => EF.Functions.Contains(x.LearningModuleDesc, stringarray)
|| EF.Functions.Contains(x.LearningModuleContent, stringarray)
);
1
1
3/18/2019 9:02:28 PM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Accepted Answer

If I understand correctly, you are looking for something like this

 var results = _context.LearningModules.Where(
   x => stringarray.Any(t => x.LearningModuleDesc.Contains(t)) || 
        stringarray.Any(t => x.LearningModuleContent.Contains(t)))
0
3/18/2019 9:21:13 PM

Related Questions

EF Core Include on multiple sub-level collections

The ...ThenInclude... pattern allows you to specify a path from the root to a ...single... leaf, hence in order to specify a path to another leaf, you need to restart the process from the root by using the ...Include... method and repeat that for each leaf....For your sample it would be like this:...Context.Set<Person>() .Include(o => o.Contact...
c# entity-framework entity-framework-core
asked by Ivan Stoev

Custom function for Include method in EF

public IQueryable<Singer> Singers { get; set; } ...Should be...public List<Singer> Singers { get; set; } ...The Exception message pretty much states exactly what is wrong and what it should be changed to. You can use almost any type that derives from either ...HashSet<>... or ...List<>....
asp.net-core c# entity-framework entity-framework-core repository-pattern
asked by Igor

Does EF Core allow a unique column to contain multiple nulls?

Yes, you can do that with EF Core, as a Unique index by default is created as a filtered index (WHERE ... IS NOT NULL)...config.Entity<Product>() .HasIndex(b => b.ProductId) .IsUnique(); ...https://github.com/aspnet/EntityFramework/pull/2868
c# ef-code-first entity-framework entity-framework-core
asked by ErikEJ

Multiple Include/ThenInclude causing duplicates in EF Core

var data = _dbcontext.Person .Where(p => p.BuildingId == buildingId) .Include(p => p.Building) .Include(p => p.Doctor) .Include(p => p.Teacher) .Include(p => p.Farmer) .Include(p => p.Prostitute) .OrderBy(p => p.Building;
.net-core entity-framework entity-framework-core sql-server
asked by JnJnBoo

EF Generic Repository Multiple Includes

You have fallen in the typical trap of calling a method which returns something and ignoring the result. The line ...entities.Include(include);... does nothing - similar to ...entities.Where(...);..., ...entities.Select(...);... etc....The correct code is something like this:...var query = entities.AsQueryable(); foreach (var include in includes) ...
c# entity-framework-core
asked by Ivan Stoev

Retrieving multiple users including their roles with EF Core using ASP.NET Identity

I just ran into this issue the other day. I found a few resources that said I should establish relationships and set up props in the ...ApplicationUser... object, but I did not want to go down that route. I ended up just using a LINQ query expression to build the data I needed....var usersWithRoles = ( from u in _db.Users select new { Id ...
asp.net-core asp.net-identity c# entity-framework-core
asked by David Lee

EF Core Include on multiple sub-level collections

The ...ThenInclude... pattern allows you to specify a path from the root to a ...single... leaf, hence in order to specify a path to another leaf, you need to restart the process from the root by using the ...Include... method and repeat that for each leaf....For your sample it would be like this:...Context.Set<Person>() .Include(o => o.Contact...
c# entity-framework entity-framework-core
asked by Ivan Stoev

EF Core ICollection does not contain a definition for 'Include'

If developing on .NET - make sure you are using the System.Data.Entity namespace....using System.Data.Entity; ...If on .NET Core - use Microsoft.EntityFrameworkCore instead....using Microsoft.EntityFrameworkCore;
c# ef-core-2.1 entity-framework entity-framework-core
asked by Fábio Nascimento

Why the include function is not including the navigational property of the model?

I have these 2 models:...Phones:...public class Phones { public int ID { get; set; } public string Model { get; set; } public string Manufacturer { get; set; } // e.g. XIAOMI, NOKIA, IPHONE public int UserID { get; set; } public List<Users> Users { get; set; } } ...Users:... public class Users ...
c# ef-code-first entity-framework entity-framework-6 model-view-controller
asked by azure boy

System.Private.CoreLib: Exception while executing function: System.Data.SqlClient: Keyword not supported: 'authentication'

The exception is expected for now, check the ...thread.......SqlClient for .NET Core still does not support using the 'authentication' keyword in the connection string. That will happen when ...this issue... is actually fixed....In order to use AAD in the new version of SqlClient in .NET Core 2.2, customers need to obtain the access token themselve...
.net-core azure azure-functions azure-sql-database entity-framework-core
asked by Jerry Liu

EF Core's Include() function not working from direct GET request

I am building this app using.NET Core 3.1 and my json output isn't right. Here is the class I want a list of:...[DataContract(IsReference = true)] public class State { public int Id { get; set; } [DataMember] public string Name { get; set; } [DataMember] public List<Region> Regions { get; } public State() { Na...
asp.net-core blazor c# entity-framework-core sql-server
asked by Bruno Blanes

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