Thanks @vsr1 . For some reason query takes 4.6 s to execute in console but when used with .Net SDK takes 12 s without any serialization just to retrieve the results as dynamic. Its not the first time I see it happening though, happens in other examples as well.