Entity Framework and Sql Server view question
- by Sergio Romero
Hi to all,
For several reasons that I don't have the liberty to talk about, we are defining a view on our Sql Server 2005 database like so:
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
The idea is that the Entity Framework will create an entity based on this query, which it does, but it generates it with an error that states the following:
"warning 6002: The table/view 'Keystone_Local.dbo.MeterProvingStatisticsPoint' does not have a primary key defined. The key has been inferred and the definition was created as a read-only table/view."
And it decides that the CompletedDateTime field will be this entity primary key.
We are using EdmGen to generate the model. Is there a way not to have the entity framework include any field of this view as a primary key?
Thanks for help.