且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

带有多个StartsWith子句的LINQ查询?

更新时间:2023-02-18 19:36:44

由于每个字符串都不过是字符数组,因此您可以对其执行任何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.