I'm creating an ASP.NET Web API 2 project and I'm exposing an OData endpoint using the package Microsoft.Data.OData v5.8.2.
When I issue an orderby by a GUID column it returns the data in the same way I entered it in the database (not ordered) but issuing an orderby by another column of type string or int it works as expected.
I'm creating an ASP.NET Web API 2 project and I'm exposing an OData endpoint using the package Microsoft.Data.OData v5.8.2.
When I issue an orderby by a GUID column it returns the data in the same way I entered it in the database (not ordered) but issuing an orderby by another column of type string or int it works as expected.
Here's the URL I'm using:
http://localhost:21157/odata/C_Employees?$orderby=ID
Is this a bug or I'm doing something wrong?