Linq To xRM Issue(CRM 4.0 Online): The 'select' and 'orderBy' calls may only reference a single common entity type. -CSDN博客

本文通过一个具体的示例介绍了如何利用新的Microsoft xRM SDK来提高开发效率。作者展示了如何从不同的实体（如账户和联系人）中获取特定字段，并将其绑定到前端ASPX页面。在解决了一个关于LINQ查询的错误后，最终实现了预期的功能。

I'm taking advantage of new Microsoft.xRM SDK to improve my development productivity,

Here is an example to fetch some columns from various entities(e.g. account and contact) to bind the anoumous object list to front end aspx page later.

var crm = new Xrm.XrmDataContext("CRMOnline"); var account = from acts in crm.accounts join cts in crm.contacts on acts.primarycontactid equals cts.contactid where cts.fullname.Contains("onne") select new { AccountNumber = acts.accountnumber, PrimaryContactId = cts.contactid };

Whereas, I encountered an exception which message is "The 'select' and 'orderBy' calls may only reference a single common entity type. ".

hmm..., after my research I got some hint from the link from Adx Studio which is the real author of the microsoft xRM sdk. Please refer to the link here

Finally, I adjusted my code snippet as below(Added ToList in the linq expression),

var crm = new Xrm.XrmDataContext("CRMOnline"); var account = from acts in crm.accounts.ToList() join cts in crm.contacts on acts.primarycontactid equals cts.contactid where cts.fullname.Contains("onne") select new { AccountNumber = acts.accountnumber, PrimaryContactId = cts.contactid };

Now everything works well. Enjoy coding!