随笔分类 -  Linq

The cast to value type 'System.Decimal' failed because the materialized value is null. Either the result type's generic parameter or the query must use a nullable type.
摘要：_investmentRepository.Table.Where(t => t.CustomerId == customerId && t.InvestmentStatus == tempStatus).Sum(t =>t.Amount); 查询结果存在NULL值，在尝试将它转换成System.I 阅读全文
posted @ 2016-10-18 13:09 z_hj 阅读(1985) 评论(0) 推荐(0)
将Linq（EF）级联查询的结果转换为泛型集合类型
摘要：var result = (from a in result join b in _customerInvestmentRepository.Table on a.CustomerInvestmentId equals b.Id where b.InvestmentStatus == investm 阅读全文
posted @ 2016-10-15 17:04 z_hj 阅读(1852) 评论(0) 推荐(0)