CRM SDK 4.0.0012 now includes a Linq-to-CRM query provider

May 23, 2010 at 1:58 AM

Microsoft has published a full LINQ-to-CRM query provider in the latest SDK release (4.0.0012).  The new customer portal also also uses the new query provider.

Coordinator
May 23, 2010 at 7:56 AM

Thanks for the heads-up, I'll update the frontpage with a link.

Developer
May 24, 2010 at 9:31 PM

http://blogs.msdn.com/b/crm/archive/2010/05/13/microsoft-dynamics-crm-sdk-4-0-12-and-the-advanced-developer-extensions.aspx

"It should be emphasised that the LINQ query ultimately maps down to a QueryExpression, and hence you are as limited in the scope of queries as you currently are."

As QueryExpressions don't support everything that FetchXML does the MS code (haven't tried) could be more limited in features.

Coordinator
May 25, 2010 at 10:32 AM

@praty It's a valid point, but I think the FetchXML stuff that can't be mapped to QueryExpression is pretty marginal ("Average" anyone?). Do you have example of FetchXML features you need that aren't doable with QueryExpression?

Developer
Jun 3, 2010 at 11:02 AM

Selecting out of joined entities come to mind at least.