c# - Entity Framework : query against view in EF (C# code) returns duplicate results

Question

我正在使用 EF 查询数据库 View 。查询可以返回正确数量的记录，但所有记录都是相同的。但是，当我在 sql SSMS 中运行原始查询时，一切都很好。
有人可以提供一些关于可能的根本原因的线索吗？

View 定义如下:

 CREATE VIEW [dbo].[v_JobAEWeekly]
  AS
  SELECT        
  VCId, 
  JobRegistryId, 
  JobNamingId, 
  JobPrefix, 
  DATEADD(dd, DATEDIFF(week, CONVERT(DATETIME, '2013-01-01 00:00:00', 102), JobDate) * 7 - 2, CONVERT(DATETIME, '2013-01-01 00:00:00', 102)) AS JobDateWeekSeqStartDate,       
  COUNT(*) AS JobCounts,    
  FROM            dbo.HistoricalJobInfo
  WHERE        (JobStateId = 2) AND (TotalYieldTimeInMinutes = 0)
  GROUP BY VCId, JobRegistryId, JobNamingId, JobPrefix, DATEADD(dd, DATEDIFF(week, CONVERT(DATETIME, '2013-01-01 00:00:00', 102), JobDate) * 7 - 2, CONVERT(DATETIME, '2013-01-01 00:00:00', 102))

  GO

查询如下:

//Problem:This query will return two records but the two records are the same. 
var jobAEWeeklyHistory = contextDjs.v_JobAEWeekly.Where(x => x.JobRegistryId == 11 && x.JobDateWeekSeqStartDate > date).ToList();

Answer 1

在为您生成模型、映射和数据上下文方面，代码优先逆向工程实际上类似于数据库优先。

正如@Aducci 所建议的，您的问题很可能是由错误的实体键引起的。查看this question详细解释。