实体框架嵌套选择查询
本文关键字:查询 选择 嵌套 框架 实体 | 更新日期: 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视图。然后在视图上创建实体
或者你想要完整的实体查询?