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.
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.
No comments:
Post a Comment