In general when you use model first scenario
there are two options to change the order of the columns in your database model:
1) You could use our API for handling schema migrations programmatically
to set the order of the
columns in your database the same as the order in your domain model. The detail you should have in mind in this case is that if you have some associations between your tables you should also enable creation of
foreign key constraints. For your convenience I created a sample application which illustrates that API - find it attached.
2) If you don’t want to use the order of the columns in your domain classes you could choose to update database from model wizard
. At the summary page
choose “Create Script File” instead of “Create Script File and Execute”. Then you could manually reorder the columns in the generated script file and execute it.
I will be happy to assist you if you have further questions.
the Telerik team
Telerik OpenAccess ORM Meets ASP.NET Web API. Read more.