Linq查询中的空验证

本文关键字：验证查询 Linq | 更新日期: 2023-09-27 18:07:25

@item.qmsCallAudit.Employee.EmployeeProcesses
     .Select(e=> e.Employee1.employee_code).SingleOrDefault().ToString();

如何检查e.Employee1.employee_code为空

Linq查询中的空验证

你可以这样做:

var result = item.qmsCallAudit.Employee.EmployeeProcesses
 .Where(e => e.Employee1 != null && e.Employee1.employee_code != null)
 .Select(e=> e.Employee1.employee_code)
 .SingleOrDefault();
var code = result != null ? result.ToString() : null;

不要把ToString()放在SingleOrDefault()之后，否则会返回null，然后会抛出异常。

@item.qmsCallAudit.Employee.EmployeeProcesses.Where(e => e.Employee1.employee_code != null).Select(e => e.Employee1.employee_code).SingleOrDefault().ToString();

试试^^