linq 优化： var q6 = from a in DbGetIQueryableStoredEnergy_History join b in DbGetIQueryableEquipment_Info on aEquipmentId equals bId into tmp1

var q6 = from a in Db.GetIQueryable<StoredEnergy_History>() join b in Db.GetIQueryable<Equipment_Info>() on a.EquipmentId equals b.Id join c in Db.GetIQueryable<Equipment_Type>() on b.EquipmentTypeId equals c.Id where a.Deleted == false && a.RecordTime >= startTime && a.RecordTime <= endTime && b.IsEnable == true && b.Deleted == false && b.EnterpriseId == enterpriseId && c.IsEnable == true && c.Deleted == false && c.TypeName == EquipmentType.储能.ToString() select new { ThisCityChargingCapacityPrice = a.ThisCityChargingCapacityPrice ?? 0,
ThisCityDischargeCapacityPrice = a.ThisCityDischargeCapacityPrice ?? 0, ThisAvgDischargeCapacityPrice = a.ThisAvgDischargeCapacityPrice ?? 0 } into q select new { CapacityPrice = (q.ThisCityDischargeCapacityPrice + q.ThisAvgDischargeCapacityPrice - q.ThisCityChargingCapacityPrice) }