SQL Column Order?

[Colin]

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.

[Ivailo]

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

[Colin]

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.

[Ivailo]

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

[Colin]

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.

[Andrzej]

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.

[Ivailo]

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