首页 > 其他 > 详细

Nullable object must have a value

时间:2019-04-25 16:38:46      阅读:172      评论:0      收藏:0      [点我收藏+]

有一个linq查询,由inner join改成left join, 对于有空值,就会出现Nullable object must have a value 的错误.

原来的查询:

 var qry =
            from c in _context.CCC
            join f in _context.FFF .Where(t=>t.IsActive==true)
            on  new { c.ProjectId, cat = c.Category } equals new { f.ProjectId, cat = f.Category }
            where  c.IsActive == true 
            select
            new
            {
                c.Id,
                f.category
         }

 

left join, select的字段做null判断

 var qry =
            from c in _context.CCC
            join f in _context.FFF .Where(t=>t.IsActive==true)
            on  new { c.ProjectId, cat = c.Category } equals new { f.ProjectId, cat = f.Category }
            into temp
            from tt in temp.DefaultIfEmpty()
            where  c.IsActive == true 
            select
            new
            {
                c.Id,
                category=(f==null)?‘‘:f.category
         }

 

Nullable object must have a value

原文:https://www.cnblogs.com/zitjubiz/p/10768967.html

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!