locked
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

Answers

  • 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.

     

    Thanks

    Pratik

    Monday, April 21, 2008 4:39 PM
    Moderator