LINQ 多条件查询

[cpp_1]

我用的是asp.net +EF

表结构
id name sex .....

前台有一个输入框，现在需要以‘空格’为分割符输入多姓名条件进行查询

var aa = from s in _context.aa
select s;

aa=aa.Where(s => s.name.Contains(searchString))


原来一个条件可以用Contains直接来查询

现在如果输入 【测试 用户 其它。。】这种多条件，怎么写这个表达式

[正怒月神]

string[] str={测试 用户 其它} aa=aa.Where(s =>str.Contains( s.name))

[cpp_1]

string[] str = { "测试", "用户" ,"其它" }; aa=aa.Where(s =>str.Contains( s.name)) 用这种方式，过滤以后，一条数据也没有了

[cpp_1]

[guanyinsishengzi]

aa = aa.Where(s => str.Any( ss => s.name.Contains(ss)))

[cpp_1]

The LINQ expression 'DbSet<PcInfo>() .Where(p => __str_0 .Any(xx => p.name.Contains(xx)))' could not be translated. Either rewrite the query in a form that can be translated, or switch to client evaluation explicitly by inserting a call to 'AsEnumerable', 'AsAsyncEnumerable', 'ToList', or 'ToListAsync'. See https://go.microsoft.com/fwlink/?linkid=2101038 for more information.