SQL Column Order?

7 posts, 0 answers
  1. Colin
    Colin avatar
    19 posts
    Member since:
    Jun 2011

    Posted 29 Sep 2011 Link to this post

    Hi all,

    Again sorry for the newbie questions, i'm sure they'll be a lot more coming :)

    After creating my EntityDiagram and generating my entity, i've updated my SQL database from the Model and bingo! my table has been created successfully. One thing i've noticed is that the table columns in SQL management studio are showing in a different order (i.e not the same order as in my EntityDiagram), they seem to be in descending column name order.

    Is there any way of re-ording them or when updating the database from the model they can be ordered the same as my entity??

    I hope someone can shed some light on this.

    Many thanks,

    Colin.
  2. Ivailo
    Admin
    Ivailo avatar
    318 posts

    Posted 03 Oct 2011 Link to this post

    Hi Colin,

    Unfortunately as per the current design the column ordering is fixed and cannot be changed. The database script is always generated with the columns sorted by name, descending.

    We are aware of this limitation of Telerik OpenAccess ORM and it will probably be addressed in one of our future releases.

    Do not hesitate to contact us if you have any other questions.


    Best wishes,
    Ivailo
    the Telerik team

    Thank you for being the most amazing .NET community! Your unfailing support is what helps us charge forward! We'd appreciate your vote for Telerik in this year's SQL Server Community Awards. We are competing in TWO categories and every vote counts! VOTE for Telerik NOW >>

  3. DevCraft banner
  4. Colin
    Colin avatar
    19 posts
    Member since:
    Jun 2011

    Posted 17 Feb 2012 Link to this post

    Hi again,

    Having just installed the latest version of ORM i still see that the column ordering hasn't been changed. Is this something that will be changed or just something that I have to live with should I choose to use ORM?

    Colin.
  5. Ivailo
    Admin
    Ivailo avatar
    318 posts

    Posted 22 Feb 2012 Link to this post

    Hi Colin,

    Allowing customization on the column ordering in the DDL script is something that is already in our backlog and in the long run it might get implemented, we have not given up on this. However, it is not planned for implementation yet so for the time being we cannot offer any deadline or release number for it to be changed. You can refer to the PITS item #7707 "The order of generated SQL columns is different than the order of the class properties".

    Please accept our apologies if that is causing you any inconvenience.

    All the best,
    Ivailo
    the Telerik team
    Telerik OpenAccess ORM Q1 2012 release is here! Check out what's new or download a free trial >>
  6. Colin
    Colin avatar
    19 posts
    Member since:
    Jun 2011

    Posted 23 Feb 2012 Link to this post

    Ok thanks, but it is a major inconvenience and making us rethink our move to ORM at present :( I have discussed this in length at DevConnections last November, it's a real show stopper and I cannot believe it messes with the column order when it has no reason to.
  7. Andrzej
    Andrzej avatar
    1 posts
    Member since:
    May 2012

    Posted 16 Feb 2013 Link to this post

    Any chance this has been addressed.  It's been a couple years now.  It's really a great product and I've use it for most of my data modeling but it is really a pain to have to rebuilt my tables using the the correct column order.
  8. Ivailo
    Admin
    Ivailo avatar
    318 posts

    Posted 25 Feb 2013 Link to this post

    Hello Andrzej,

    Unfortunately this feature request has not been implemented yet. However, it is gaining popularity on our Public Issue Tracking System - you can also vote for it here. Based on the votes, we will probably be implementing some improvement in the near future.

    Do not hesitate to contact us with any ideas of functionality that would make OpenAccess a better product.
     

    Regards,
    Ivailo
    the Telerik team
    Q3'12 SP1 of OpenAccess ORM packs Multi-Table Entities mapping support. Check it out.
Back to Top
DevCraft banner