Order of results RRS feed

  • Question


    Hi Guys,


    I've created a table which has several tables inherting from it. When I view the data in a webbrowser the default sort order is not according to the parent table primary key, it seems to be alphabetically by the entry adsm:type and then the primary key.


    Is this intentional?

    Thursday, April 10, 2008 3:04 PM


  • The ordering depends on the provider. I am guessing that you are using EF as your underlying provider. If yes, since you have data across several tables, and each table contains data about a certain type (Table per type scheme), you are seeing this behaviour.


    You can verify this by running a query directly against EF. Hope this helps.




    Monday, April 21, 2008 4:39 PM