LINQ to SQL-where子句中的可为空类型 [英] LINQ to SQL - nullable types in where clause

问题描述

我有一个表，其中的列具有空值...当我尝试查询该列为NULL的记录时:

I have a table with a column that has null values... when I try to query for records where that column IS NULL:

此工作:

        var list = from mt in db.MY_TABLE
                   where mt.PARENT_KEY == null
                   select new { mt.NAME };

这不是:

        int? id = null;
        var list = from mt in db.MY_TABLE
                   where mt.PARENT_KEY == id
                   select new { mt.NAME };

为什么?

推荐答案

经过更多的谷歌搜索后，我找到了答案:

after some more googling, I found the answer:

参考#1

参考#2

int? id = null;
var list = from mt in db.MY_TABLE
           where object.Equals(mt.PARENT_KEY, id)  //use object.Equals for nullable field
           select new { mt.NAME };

此LINQ如下显示为SQL:

((mt.PARENT_KEY IS NULL) AND (@id IS NULL)) 
OR ((mt.PARENT_KEY IS NOT NULL) AND (@id IS NOT NULL) AND (mt.PARENT_KEY = @id))

这篇关于LINQ to SQL-where子句中的可为空类型的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！