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
Nifty50 & Bank Nifty Impact – Tariffs, Fraud Case, AGR Update (Aug 26, 2025)
NIFTY50 IMPACT ANALYSIS Major Negative Pressures: Trump's 50% Tariff Bomb – Tariffs effective August 27, 2025 on Indian goods; 66%...
-
GST Questions and Answers Q51) How do you handle ITC on goods sent for job work? ...
-
Plugin Interview Questions: 1. Explain in details about the event execution pipeline. 2. When do we register a plugin in a...
-
GAC (Global Assembly Cache):- Plugin stored in GAC does not support Dynamics 365 Online. Plugin does not backed up with d...
No comments:
Post a Comment