实体框架对象缺少相关数据

问题描述：

我有一个实体框架模型，有两个表，客户端和邮政编码。邮政编码可以有很多客户，客户可以有1个邮政编码。他们加入邮编。这两个表被映射到视图。实体框架对象缺少相关数据

我有一些客户在模型中没有邮政编码，但是在他们的数据库中呢！

我跑了一些测试，并发现当我做Postcode.Clients返回客户端的邮政编码，但不是所有的客户端？在db中，邮编有14个相关的客户端，但是EF只返回了前6个。基本上某些邮编没有返回所有的数据。

懒惰加载打开，我试图关闭它没有任何运气。

任何想法？

我使用VS 2010，C＃，.NET 4.0，EF4和SQL Server 2008

感谢

UPDATE：

我走过这LinqPad已经运行。我尝试下面的代码

Client c = Clients.Where(a => a.ClientId == 9063202).SingleOrDefault(); 
c.PostcodeView.Dump();

这将返回null。

我再取生成的SQL，并在一个单独的SQL查询运行这个，它工作正常（在我的@添加到变量名的开始）

SELECT TOP (2) 
[Extent1].[ClientId] AS [ClientId], 
[Extent1].[Surname] AS [Surname], 
[Extent1].[Forename] AS [Forename], 
[Extent1].[FlatNo] AS [FlatNo], 
[Extent1].[StNo] AS [StNo], 
[Extent1].[Street] AS [Street], 
[Extent1].[Town] AS [Town], 
[Extent1].[Postcode] AS [Postcode] 
FROM (SELECT 
     [ClientView].[ClientId] AS [ClientId], 
     [ClientView].[Surname] AS [Surname], 
     [ClientView].[Forename] AS [Forename], 
     [ClientView].[FlatNo] AS [FlatNo], 
     [ClientView].[StNo] AS [StNo], 
     [ClientView].[Street] AS [Street], 
     [ClientView].[Town] AS [Town], 
     [ClientView].[Postcode] AS [Postcode] 
     FROM [dbo].[ClientView] AS [ClientView]) AS [Extent1] 
WHERE 9063202 = [Extent1].[ClientId] 
GO 

-- Region Parameters 
DECLARE @EntityKeyValue1 VarChar(8) = 'G15 6NB' 
-- EndRegion 
SELECT 
[Extent1].[Postcode] AS [Postcode], 
[Extent1].[ltAstId] AS [ltAstId], 
[Extent1].[ltLhoId] AS [ltLhoId], 
[Extent1].[ltChcpId] AS [ltChcpId], 
[Extent1].[ltCppId] AS [ltCppId], 
[Extent1].[ltWardId] AS [ltWardId], 
[Extent1].[ltAst] AS [ltAst], 
[Extent1].[ltCpp] AS [ltCpp], 
[Extent1].[ltWard] AS [ltWard], 
[Extent1].[WardNo] AS [WardNo], 
[Extent1].[Councillor] AS [Councillor], 
[Extent1].[ltAdminCentre] AS [ltAdminCentre], 
[Extent1].[ltChcp] AS [ltChcp], 
[Extent1].[Forename] AS [Forename], 
[Extent1].[Surname] AS [Surname], 
[Extent1].[AreaNo] AS [AreaNo], 
[Extent1].[LtAomId] AS [LtAomId], 
[Extent1].[OOHltCoordinatorId] AS [OOHltCoordinatorId], 
[Extent1].[OvernightltCoordinatorId] AS [OvernightltCoordinatorId], 
[Extent1].[DayltCoordinatorId] AS [DayltCoordinatorId] 
FROM (SELECT 
     [PostcodeView].[Postcode] AS [Postcode], 
     [PostcodeView].[ltAstId] AS [ltAstId], 
     [PostcodeView].[ltLhoId] AS [ltLhoId], 
     [PostcodeView].[ltChcpId] AS [ltChcpId], 
     [PostcodeView].[ltCppId] AS [ltCppId], 
     [PostcodeView].[ltWardId] AS [ltWardId], 
     [PostcodeView].[ltAst] AS [ltAst], 
     [PostcodeView].[ltCpp] AS [ltCpp], 
     [PostcodeView].[ltWard] AS [ltWard], 
     [PostcodeView].[WardNo] AS [WardNo], 
     [PostcodeView].[Councillor] AS [Councillor], 
     [PostcodeView].[ltAdminCentre] AS [ltAdminCentre], 
     [PostcodeView].[ltChcp] AS [ltChcp], 
     [PostcodeView].[Forename] AS [Forename], 
     [PostcodeView].[Surname] AS [Surname], 
     [PostcodeView].[AreaNo] AS [AreaNo], 
     [PostcodeView].[LtAomId] AS [LtAomId], 
     [PostcodeView].[DayltCoordinatorId] AS [DayltCoordinatorId], 
     [PostcodeView].[OOHltCoordinatorId] AS [OOHltCoordinatorId], 
     [PostcodeView].[OvernightltCoordinatorId] AS [OvernightltCoordinatorId] 
     FROM [dbo].[PostcodeView] AS [PostcodeView]) AS [Extent1] 
WHERE [Extent1].[Postcode] = @EntityKeyValue1

显示一些代码可能会有所帮助。 – Yakimych 2010-12-16 12:50:34

我不知道你在这里问什么 - 但你有没有尝试过急切的加载：'Client c = Clients.Include（“Postcode”）。Where（a => a.ClientId == 9063202）.SingleOrDefault（）;'btw - 你可以在'SingleOrDefault'方法中使用谓词 - 你不需要Where方法。 – RPM1984 2010-12-16 20:55:56

@ RPM1984 - 我认为这里的问题在于，实体框架生成的SQL语句在直接在sql中运行时返回不同的结果，而与使用关联访问客户端和邮编时发生的情况相反 – littlechris 2010-12-16 23:26:59

答

端却取消的关系和手动获取儿童数据。讨厌，但无法找到发生这种情况的原因。欢呼的评论

实体框架对象缺少相关数据

相关推荐