当任何一列可能为空时,如何使用 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/

10-15 04:19
查看更多