Linq分组.include（“表”）在表上返回null [英] Linq grouping .include("Table") returning null on Table

问题描述

我需要加载表AssessmentQuestionsReference，以便我可以绑定到我的WPF应用程序中。

  var groupedAnswers = from a in App.ents.AssessmentAnswers.Include（AssessmentQuestions）
 where a。 Organisations.OrganisationID == App.selectedOrganisation.OrganisationID 
 group a by a.AssessmentQuestions.AssessmentQuestionGroups.QuestionGroup into g 
 select new {Group = g.Key，Answer = g}; 
  

当我深入研究g时，AssessmentQuestions是null。我不知道为什么，因为我认为它应该已经加载它甚至没有包括，因为我正在通过该表获取问题组。

任何想法？你有没有尝试过包括 AssessmentQuestions.AssessmentQuestionGroups ？

解决方案
$ b $ <您的 .Include（AssessmentQuestions）将拉入 a.AssessmentQuestions ，但不是 a.AssessmentQuestions.AssessmentQuestionGroups 。

I have a linq query that is grouping by answers by QuestionGroup.

I need to have the table AssessmentQuestionsReference load so that i can bind to it in my WPF app.

   var groupedAnswers = from a in App.ents.AssessmentAnswers.Include("AssessmentQuestions")
                        where a.Organisations.OrganisationID == App.selectedOrganisation.OrganisationID
                        group a by a.AssessmentQuestions.AssessmentQuestionGroups.QuestionGroup into g
                        select new { Group = g.Key, Answer = g };

When i drill down into g, AssessmentQuestions is "null". I am not sure why as i thought it should have loaded it even without the include as i am going through that table to get the question groups.

Any ideas?

解决方案

Have you tried including AssessmentQuestions.AssessmentQuestionGroups?

Your .Include("AssessmentQuestions") will pull in a.AssessmentQuestions, but not a.AssessmentQuestions.AssessmentQuestionGroups.

这篇关于Linq分组.include（“表”）在表上返回null的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！