[entity-framework] 엔터티 프레임 워크 및 SQL Server보기

내가 말할 자유가없는 몇 가지 이유로, 우리는 다음과 같이 Sql Server 2005 데이터베이스에 대한 견해를 정의하고 있습니다.

CREATE VIEW [dbo].[MeterProvingStatisticsPoint]
AS
SELECT
    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

아이디어는 Entity Framework 가이 쿼리를 기반으로 엔티티를 작성하지만 다음과 같은 오류로 생성합니다.

경고 6002 : 테이블 / 뷰 ‘Keystone_Local.dbo.MeterProvingStatisticsPoint’에 기본 키가 정의되어 있지 않습니다. 키가 유추되었으며 정의가 읽기 전용 테이블 / 뷰로 작성되었습니다.

그리고 CompletedDateTime 필드가이 엔티티 기본 키가되도록 결정합니다.

우리는 EdmGen을 사용하여 모델을 생성하고 있습니다. 엔터티 프레임 워크에이 뷰의 필드를 기본 키로 포함시키지 않는 방법이 있습니까?

답변

SELECT
  ISNULL(MyPrimaryID,-999) MyPrimaryID,
  NULLIF(AnotherProperty,'') AnotherProperty
  FROM ( ... ) AS temp

 Create table OrderDetail
    (
       Id int primary key,
       CustomerId int references Customer(Id),
       Amount decimal default(0)
    );
 Create index ix_customer on OrderDetail(CustomerId);

 Create view CustomerView
    As
      Select
          IsNull(CustomerId, -1) as CustomerId, -- forcing EF to use it as key
          Sum(Amount) as Amount
      From OrderDetail
      Group by CustomerId

Group by CustomerId

Group by IsNull(CustomerId, -1)

SELECT
ISNULL(P.ID, - 1) AS ID,
COALESCE (P.PurchaseAgent, U.[User Nickname]) AS PurchaseAgent,
COALESCE (P.PurchaseAuthority, 0) AS PurchaseAuthority,
COALESCE (P.AgencyCode, '') AS AgencyCode,
COALESCE (P.UserID, U.ID) AS UserID,
COALESCE (P.AssignPOs, 'false') AS AssignPOs,
COALESCE (P.AuthString, '') AS AuthString,
COALESCE (P.AssignVendors, 'false') AS AssignVendors
FROM Users AS U
INNER JOIN Users AS AU ON U.Login = AU.UserName
LEFT OUTER JOIN PurchaseAgents AS P ON U.ID = P.UserID

SELECT
ROW_NUMBER() OVER(ORDER BY A,B) AS Id,
A, B
FROM SOMETABLE