D365 executeStaticQuery alternative

(1) Share

Report

Posted on by Eisenberk

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,