實(shí)體框架和SQL Server視圖由于幾個(gè)我無權(quán)談?wù)摰脑?,我們?cè)赟ql Server 2005數(shù)據(jù)庫(kù)中定義了一個(gè)視圖,如下所示:CREATE VIEW [dbo].[MeterProvingStatisticsPoint]ASSELECT
CAST(0 AS BIGINT) AS 'RowNumber',
CAST(0 AS BIGINT) AS 'ProverTicketId',
CAST(0 AS INT) AS 'ReportNumber',
GETDATE() AS 'CompletedDateTime',
CAST(1.1 AS float) AS 'MeterFactor',
CAST(1.1 AS float) AS 'Density',
CAST(1.1 AS float) AS 'FlowRate',
CAST(1.1 AS float) AS 'Average',
CAST(1.1 AS float) AS 'StandardDeviation',
CAST(1.1 AS float) AS 'MeanPlus2XStandardDeviation',
CAST(1.1 AS float) AS 'MeanMinus2XStandardDeviation'WHERE 0 = 1我們的想法是,實(shí)體框架將基于此查詢創(chuàng)建一個(gè)實(shí)體,但它會(huì)生成一個(gè)包含以下內(nèi)容的錯(cuò)誤:警告6002:表/視圖'Keystone_Local.dbo.MeterProvingStatisticsPoint'沒有定義主鍵。已推斷密鑰,并將定義創(chuàng)建為只讀表/視圖。并且它決定CompletedDateTime字段將是此實(shí)體主鍵。我們正在使用EdmGen生成模型。有沒有辦法不讓實(shí)體框架包含此視圖的任何字段作為主鍵?
實(shí)體框架和SQL Server視圖
慕尼黑8549860
2019-08-09 16:13:07