C# linq int类型为null异常

最新推荐文章于 2024-09-13 10:05:17 发布

问道江湖

最新推荐文章于 2024-09-13 10:05:17 发布

阅读量766

点赞数

文章标签： linq c# 开发语言

本文链接：https://blog.csdn.net/wangzhediqi/article/details/128998262

版权

C# 专栏收录该内容

2 篇文章 0 订阅

订阅专栏

异常堆栈

fail: Microsoft.EntityFrameworkCore.Query[10100]
      An exception occurred while iterating over the results of a query for context type 'SdVipServer.SdModels.SdDBContext'.
      System.InvalidOperationException: Nullable object must have a value.
         at lambda_method879(Closure, QueryContext, DbDataReader, ResultContext, SingleQueryResultCoordinator)
         at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.Enumerator.MoveNext()
      System.InvalidOperationException: Nullable object must have a value.
         at lambda_method879(Closure, QueryContext, DbDataReader, ResultContext, SingleQueryResultCoordinator)
         at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.Enumerator.MoveNext()
fail: SdVipServer.Program[0]
      An error occurred creating the DB.
      System.InvalidOperationException: Nullable object must have a value.
         at lambda_method879(Closure, QueryContext, DbDataReader, ResultContext, SingleQueryResultCoordinator)
         at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.Enumerator.MoveNext()
         at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)
         at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source)

报错的LINQ代码

from t in dbContext.LTraders
                           join p in dbContext.DShops on t.Shopid equals p.Shopid into result1
                           from row1 in result1.DefaultIfEmpty()
                           join d in dbContext.DsDistributors on t.Traderid equals d.Clientid into result2
                           from row2 in result2.DefaultIfEmpty()
                           where (t.Traderid > 0)   && (row2.Status == null || row2.Status == 1) 
                           orderby t.Code
                           select new {
                               t.Traderid, t.Shipto, t.Scamt, t.Code, t.Name, t.Areaid,
                               t.Countryid, t.Isvendor, t.Isclient, t.Isother, t.Credit, t.Creditday,
                               t.Closed, t.Suramt, t.Speedsymbol, t.Iscashtrader, t.Shopid, t.Acctrader,
                               t.Paymethodid, t.TaxRate,
                               Shopname = row1.Name ?? "",
                               t.Moneyid, t.Empid, t.Departmentid,
                               t.Isexpress, Distributorid =(row2.Distributorid == null ? 0 : row2.Distributorid), row2.Kind ,
                               t.Contactor
                           };