当任何一列可能为空时,如何使用 LINQ to SQL 搜索多个列?
IEnumerable<User> users = from user in databaseUsers
where
user.ScreenName.Contains(search)
|| user.FirstName.Contains(search)
|| user.LastName.Contains(search)
select user;
我不断收到此异常:
最佳答案
添加非空条件 user.Property != null
IEnumerable<User> users = from user in databaseUsers
where
(user.ScreenName != null && user.ScreenName.Contains(search))
|| (user.FirstName != null && user.FirstName.Contains(search))
|| ( user.LastName != null && user.LastName.Contains(search))
select user;
关于c# - 包含对多列的查询,我们在Stack Overflow上找到一个类似的问题:https://stackoverflow.com/questions/5757364/