Search code examples
dynamics-crm

C# MSCRM SDK QueryExpression Default Order


I would like to know what the default sort order of the QueryExpression object. I can't seem to find it anywhere


Solution

  • I believe the default sort order will be by the ID (primary key). That's the clustered index of each entity table. When no order is specified, FetchXML returns records sorted by GUID. enter image description here