实体框架嵌套选择查询

本文关键字:查询 选择 嵌套 框架 实体 | 更新日期: 2023-09-27 18:11:52

我有一个SQL查询,我应该在实体框架中使用它。我是Entity的新手,我不知道该怎么做。我的查询是:

SELECT EKIP,
       COUNT (SAGLA) AS KPISAYISI
FROM
  (SELECT M.APPLICATIONID AS ORTAM,
          MNAME AS SERVIS,
          sum(AVAIL*HIT)/SUM(HIT) AS SAGLA,
          SUM(HIT) AS CAGRI ,
     (SELECT DOMAINNAME
      FROM SOAGOVERNANCE_SERVICE D
      WHERE D.NAME=m.MNAME
        AND D.APPLICATIONID=m.APPLICATIONID) AS EKIP
   FROM SOAGOVERNANCE_METRICLOG m
   WHERE MDATE BETWEEN '2013-01-01 01:00:00' AND '2013-02-01 01:00:00'
     AND MTYPE='SERVICE'
   GROUP BY APPLICATIONID,
            MNAME) S
WHERE S.CAGRI > 3
  AND S.SAGLA<90
GROUP BY EKIP
ORDER BY EKIP

实体框架嵌套选择查询

最简单的方法是用查询创建一个sql视图。然后在视图上创建实体

或者你想要完整的实体查询?