带有多个StartsWith子句的LINQ查询? [英] LINQ query with multiple StartsWith clause?

问题描述

我有一个LINQ查询，其工作原理如下:

I have a LINQ query that works as it is supposed to as follows,

var query = DataContext.TenantDataServerTables.Where(p => 
             p.Nursing_Home_Section == homeSection &&
             p.Tenant_Kana_Last.ToString().StartsWith(@"ア") ||
             p.Tenant_Kana_Last.ToString().StartsWith(@"イ") ||
             p.Tenant_Kana_Last.ToString().StartsWith(@"ウ") ||
             p.Tenant_Kana_Last.ToString().StartsWith(@"エ") ||
             p.Tenant_Kana_Last.ToString().StartsWith(@"オ"));
        }

有没有办法做这样的事情来简化查询?

Is there a way to do something like this to streamline the query?

char[] array = new char[] { 'ア', 'イ', 'ウ', 'エ', 'オ' };

var query = DataContext.TenantDataServerTables.Where(p => 
                 p.Nursing_Home_Section == homeSection &&
                 p.Tenant_Kana_Last.ToString().StartsWith(array));

这只是一个示例，因为我必须在LINQ查询中检查StartsWith的更多字符.

This is just an example as there are many more characters that I have to check StartsWith on the LINQ query.

推荐答案

由于每个字符串都不过是字符数组，因此您可以对其执行任何linq.只需使用第一个字符并使用 Contains :

As every string is nothing but an array of characters you could do any linq on it. Just use the very first character and check if it part of your array using Contains:

var query = DataContext.TenantDataServerTables.Where(p => 
             p.Nursing_Home_Section == homeSection &&
             array.Contains(p.Tenant_Kana_Last.ToString()[0]));

可选地，您也可以使用p.Tenant_Kana_Last.First()代替p.Tenant_Kana_Last.ToString()[0].

Alternativly to p.Tenant_Kana_Last.ToString()[0] you can also use p.Tenant_Kana_Last.First() which is a bit easier to read.

这篇关于带有多个StartsWith子句的LINQ查询?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！