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)
);
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)))
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow