Announcements
No record found.
Which is the fastest approach for retrieve data? i.e OData query,Fetchxml or any other option
*This post is locked for comments
If it is c#, then I will suggest you Linq. For Javascript, If you want to retrieve the records where using multiple conditions for Same fields, then you can achieve through Soap using Fetch XML. Or elseOData will be good.
Hi,
I believe everything is (or will be ) routed through Web API. OData and Soap endpoints are being deprecated, even though they are still working. From the C# standpoint, QueryExpression and Linq are not "native" for Dynamics - they'll be converted to FetchXml.
So, in a way, FetchXml is, probably, the fastest on the C# side. Unless you want to access Web API directly, but that might be too much troubles and I'm not sure you'll really be able to see any performance improvement.
Hi Bala,
If you are using server side code like CRM object model, then it will be first converted to FetchXML first and then executed, so writing FetchXML would be faster as it saves one conversion step.
WebAPI is the way forward, as MS will soon be deprecating OData endpoints.
Regards,
Pranav
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our 2026 Super Stars!
We are thrilled to have these Champions in our Community!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
JS-09031509-0 3
AS-17030037-0 2
Mark Eckert 2
