Sunday, 8 September 2013

Fetch XMl VS Query Expression in Mscrm 2011

When developer want to query in MSCRM 2011 often thinks of Query Expression or Fetch XMl.
A question arises in  developer mind what is the difference and which one is better.
Fetch is a proprietary query language that is used in Microsoft Dynamics CRM. It is based on a schema that describes the capabilities of the language. The FetchXML language supports similar query capabilities as query expression
Using fetch XML one can get in result attribute from related  entity also but not in Query expression. using FetchXML , you can set the Related Entity columns in filter criteria to return the Query Result. FetchXml allows the querying of CRM data using an XML representation.

Querying CRM DB using QueryExpression one cannot able to set Related Entity columns as filter criteria to return the Query Result.