我有一个查询,它给了我一个异常。现在 j.job_quote.JobQuoteID 是一个标识列,但是它是空的,所以我正在尝试创建一个检查,如果为空则将其标识为0。请帮忙解决问题并告诉我如何处理。
var Qryjob = (from j in at.jobs
where j.JobID == Convert.ToInt32(jobid)
select new {
JobID = j.JobID,
InsertedDate = j.InsertedDate,
FirstName = j.user.FirstName,
LastName = j.user.LastName,
City = j.user.City,
ServiceName = j.service.ServiceName,
ServiceTypeName = j.service_type.ServiceTypeName,
BudgetName = j.budget.BudgetName,
IsApproved = j.IsApproved,
IsAssigned = j.IsAssigned,
IsQuoted = j.IsQuoted,
job_notif_price = j.job_notif_price,
Description = j.Description,
PaymentTypeName = j.payment_type.PaymentTypeName,
DuePeriodName = j.due_period.DuePeriodName,
QuoteStatus = j.job_quote.QuoteStatus,
JobStatus = j.job_quote.JobStatus,
comments = j.job_quote.comments,
IsPartnerApply = j.job_quote.IsPartnerApply,
Applycomment = j.job_quote.ApplyComments,
JobQuoteID = j.job_quote.JobQuoteID ?? 0
}).ToList();