为什么MSSQL数据库有些视图通过EF导不进edmx里面

视图代码如下：

WITH t_InitIngSum AS (SELECTCONVERT(date, led.CreateTime, 120) AS queryDate,SUM(led.LendMoney) AS InitIngSummssql 使用视图, COUNT(mem.UserName) AS initUserSum

FROMdbo.Members AS mem LEFT OUTER JOIN

dbo.MemberLend AS led ON led.UserName = mem.UserName LEFT OUTER JOIN

dbo.MemberBorrow AS mmb ON mmb.BID = led.BID

WHERE(led.IsSuccess = 0) AND (led.IsExceed = 0) AND (mmb.IsSuccess IN ('2', '3'))

GROUP BY CONVERT(date, led.CreateTime, 120)), t_InitEdSum AS

(SELECTCONVERT(date, led.SuccessTime, 120) AS queryDate, SUM(led.LendMoney) AS InitEdSum, COUNT(mem.UserName) AS ininEnUserSum

FROMdbo.Members AS mem LEFT OUTER JOIN

dbo.MemberLend AS led ON led.UserName = mem.UserName LEFT OUTER JOIN

dbo.MemberBorrow AS mmb ON mmb.BID = led.BID

WHERE(led.IsSuccess = 1) AND (led.IsExceed = 0) AND (mmb.IsSuccess = '5')

GROUP BY CONVERT(date, led.SuccessTime, 120))

SELECT DISTINCT CONVERT(date, led.CreateTime, 120) AS queryDate, iis.InitIngSum, iis.initUserSum, ids.InitEdSum, ids.ininEnUserSum

FROMdbo.MemberLend AS led LEFT OUTER JOIN

t_InitEdSum AS ids ON ids.queryDate = CONVERT(date, led.CreateTime, 120) LEFT OUTER JOIN

t_InitIngSum AS iis ON iis.queryDate = CONVERT(date, led.CreateTime, 120)

（编辑：92站长网）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!