Wednesday, July 7, 2021
Difference between Query Expression AND Fetch XML query
Query Expression:- It is the mostly commonly used way for querying information in CRM. Probably because it uses the object-oriented style of coding and so you have distinct classes for query, condition, columns etc. You have intelligence to support you when writing a query using Query Expression.
However, it has its own limitations, one of them being the inability to provide a column of a linked entity to be returned as the query result. This perhaps because the Query Expression would return a dynamic entity or a strongly typed base entity and so it is unable to return columns of related entity.
Fetch XML Query :- Fetch XML requires the query to be specified in XML format and the result set is returned in XML format as well. This allows Fetch XML to return related entity columns as well as this is just another node in the xml doc.
Subscribe to:
Post Comments (Atom)
Featured Post
-
Merging PDF Files Based on Name Segments in C# In this blog post, we will explore how to merge multiple PDF files using C#. The me...
-
Dynamics CRM Questions and Answers Q251) How do you create and manage multiple forms for a single entity? + T...
-
Automating Email with VBA In this blog post, I will walk you through a VBA script that automates the process ...
No comments:
Post a Comment