Skip to main content

Notifications

Announcements

No record found.

Dynamics 365 Community / Forums / Finance forum / D365 executeStaticQuer...
Finance forum
Unanswered

D365 executeStaticQuery alternative

Posted on by 81
Hi folks,
 
I am trying to access some data via OData on a C# application using DataServiceContext, but, i can't get near close to the performance that we got using the old QueryServiceClient.ExecuteStaticQuery().
 
Using Entities to read the tables and converting the results to lists or array takes too much time in my opinion. Also, the executeStaticQuery returned the results in a DataSet which was faster to iterate over the child records. Now, using ODATA, we have to use diferent entities for a child datasources which i found very bad in perfomance memory/time wise.
 
Is there any alternative?
 
Regards,
 
Eisenberk,
 

Helpful resources

Quick Links

Dynamics 365 Community Update – Sep 9th

Welcome to the next edition of the Community Platform Update. This is a weekly…

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,252 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,089 Super User 2024 Season 2

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans