select Sum(PowerInverter) PowerInverter,SUM(ThisPower) ThisPower from (select a.id,thisPower,PowerInverter,ROW_NUMBER() over( partition by EquipmentId order by RecordTime desc) as new_index from Inverter_History A left join Equipment_Info b on a.EquipmentId = b.id left join Equipment_Type c on b.EquipmentTypeId = c.Id and c.TypeName='逆变器' where b.EnterpriseId='B4C8F629-0703-4C83-8978-E955F63EB058') A WHERE new_index=1转linq

以下是将该 SQL 查询语句转换成 LINQ 查询语句的代码示例：

var result = (from a in db.Inverter_History
              join b in db.Equipment_Info on a.EquipmentId equals b.id
              join c in db.Equipment_Type on b.EquipmentTypeId equals c.Id
              where c.TypeName == "逆变器" && b.EnterpriseId == "B4C8F629-0703-4C83-8978-E955F63EB058"
              orderby a.RecordTime descending
              group new { a.id, a.thisPower, a.PowerInverter } by a.EquipmentId into g
              select new
              {
                  PowerInverter = g.FirstOrDefault().PowerInverter,
                  ThisPower = g.FirstOrDefault().thisPower
              }).Sum(x => x.PowerInverter + x.ThisPower);

注意，需要根据具体的数据上下文（`db`）和实体类进行调整，以保证代码的正确性。