在CRM 2011插件上在同一语句中使用多个JOIN时出现LINQ错误

Question

嗨，我试图在CRM 2011中加入多个实体，但我得到和错误说:{"' xrmsm_sessionregistrments '实体不包含属性Name = 'xrmsm_termsid'."}。这是正确的，但我正在加入具有该属性的实体。

My Linq Query:

var query2 = from e in svsContext.xrmsm_sessionEnrollmentsSet

        join s in svsContext.xrmsm_sessionsSet on e.xrmsm_SessionLookup.Id equals s.xrmsm_sessionsId
        join ic in svsContext.xrmsm_institutionCoursesSet on s.xrmsm_institutionCourseLookup.Id equals ic.xrmsm_institutionCoursesId
        join ts in svsContext.xrmsm_term_sessionsSet on e.xrmsm_termSessionLookup.Id equals ts.xrmsm_term_sessionsId
        join t in svsContext.xrmsm_termsSet on ts.xrmsm_TermLookup.Id equals t.xrmsm_termsId
        where (e.xrmsm_StudentLookup.Equals(studentlookup)
               && e.xrmsm_YearLookup.Equals(entity.GetAttributeValue("xrmsm_studentlookup"))
               && ic.xrmsm_institutionCoursesId == institutionCourseGuid
               && t.xrmsm_termsId == termGuid)
        select new { sessionName = s.xrmsm_sessionsName, StudentName = e.xrmsm_studentsName, StudentId = e.xrmsm_StudentLookup.Name };

我的原始SQL查询在SQL Server上工作:

SELECT en.xrmsm_currentsessionenrollmentsname
      ,en.xrmsm_isreadonlyname
      ,en.xrmsm_sessionenrollmentsaverage
      ,en.xrmsm_sessionenrollmentsgrade
      ,en.xrmsm_sessionenrollmentsid
      ,en.xrmsm_sessionenrollments_id
      ,en.xrmsm_sessionlookup as sessionid
      ,en.xrmsm_sessionlookupname
      ,en.xrmsm_sessionsname
      ,en.xrmsm_studentlookup AS studentid
      ,en.xrmsm_studentlookupname
      ,en.xrmsm_studentsname
      ,en.xrmsm_termsessionlookup
      ,en.xrmsm_termsessionlookupname
      ,en.xrmsm_withdrawal
      ,en.xrmsm_yearaverage
      ,en.xrmsm_yeargrade
      ,en.xrmsm_yearlookup
      ,en.xrmsm_yearlookupname
  FROM CoseyTest_MSCRM.dbo.Filteredxrmsm_sessionEnrollments as en INNER JOIN 
  CoseyTest_MSCRM.dbo.Filteredxrmsm_sessions crmsessions ON 
  (en.xrmsm_sessionlookup = crmsessions.xrmsm_sessionsid AND en.xrmsm_yearlookup = crmsessions.xrmsm_yearlookup)
  INNER JOIN Filteredxrmsm_institutionCourses institutionCourses
  on crmsessions.xrmsm_institutioncourselookup = institutionCourses.xrmsm_institutioncoursesid
  Inner Join Filteredxrmsm_term_sessions as termsession
  on en.xrmsm_termsessionlookup = termsession.xrmsm_term_sessionsid
  Inner Join Filteredxrmsm_terms as terms
  on termsession.xrmsm_termlookup = terms.xrmsm_termsid 
  where en.xrmsm_yearlookup = '4BA07BED-3F51-E211-8359-00155D004403' 
  and en.xrmsm_studentlookup = 'C844AF65-5B51-E211-8359-00155D004403'
  and terms.xrmsm_termsid = 'D1D107B7-4551-E211-8359-00155D004403' 
  and institutionCourses.xrmsm_institutioncoursesid = '2121914E-4551-E211-8359-00155D004403'

Answer 1

CRM的Linq提供程序有一些限制。你可以在这里找到它。检查您的查询是否违反了限制

Answer 2

试着看看它正在生成的实际查询，并在SQL中运行它，它可能有助于理解发生了什么。

可能是您在LINQ中所做的事情在CRM中不可用，正如paramosh提到的，但我看不到任何跳出来的东西。

Answer 3

感谢大家的回复。我做了下面的工作:

1. 创建一个查询，检索所有学生注册的列表

2. 使用List<T>类的Find方法查找是否存在符合我正在搜索的条件的记录。

    var query2 = (from e in svsContext.xrmsm_sessionEnrollmentsSet
                    join s in svsContext.xrmsm_sessionsSet on e.xrmsm_SessionLookup.Id equals s.xrmsm_sessionsId
                    join ic in svsContext.xrmsm_institutionCoursesSet on s.xrmsm_institutionCourseLookup.Id equals ic.xrmsm_institutionCoursesId
                    join ts in svsContext.xrmsm_term_sessionsSet on e.xrmsm_termSessionLookup.Id equals ts.xrmsm_term_sessionsId
                    join t in svsContext.xrmsm_termsSet on ts.xrmsm_TermLookup.Id equals t.xrmsm_termsId
                    where (e.xrmsm_StudentLookup.Equals(studentlookup))
                    select new
                    {
                        EnrollmentId = e.xrmsm_sessionEnrollments_id,
                        SessionId = s.xrmsm_sessions_id,
                        EnrollmentYear = e.xrmsm_YearLookup,
                        InstitutionCourseId = (Guid)ic.xrmsm_institutionCoursesId,
                        TermId = (Guid)t.xrmsm_termsId,
                        Student = e.xrmsm_StudentLookup
                    }).ToList();
   
       var q = query2.Find(r => r.EnrollmentYear.Id == entity.GetAttributeValue<EntityReference>("xrmsm_yearlookup").Id
                            && r.InstitutionCourseId == institutionCourseGuid
                            && r.TermId == termGuid);