LINQ to SQL Join和If Condition
|
我在下面有一个查询，如果bstock不为null并且bstock.Price（bstock.Price是可为null的doubel？）不为null，我想在其中设置价格。该联接是左外部联接。有人能帮我吗？
var bstocks = (from p in qry
join bstock in bstockRepository.Select() on p.StockCode equals bstock.StockCode
into J1
from bstock in J1.DefaultIfEmpty()
select new
{
p.StockCode,
p.Description,
p.ListPrice,
p.Price = bstock.Price != null ? bstock.Price : p.Price,
p.QuantityOnHand ,
p.Cube,
p.ShippingFormat,
p.Weight,
p.NextShipment,
p.NextShipment2,
p.NextShipmentQuantity,
p.NextShipment2Quantity,
Bstock = p.Bstock
}
).AsQueryable();
没有找到相关结果
已邀请:
1 个回复
莽缓逢
结果：var bstocks = (from p in qry join bstock in bstockRepository.Select() on p.StockCode equals bstock.StockCode into J1 from bstock in J1.DefaultIfEmpty() select new { p.StockCode, p.Description, p.ListPrice, Price = bstock != null && bstock.Price != null ? bstock.Price : p.Price, p.QuantityOnHand , p.Cube, p.ShippingFormat, p.Weight, p.NextShipment, p.NextShipment2, p.NextShipmentQuantity, p.NextShipment2Quantity, Bstock = p.Bstock });