When the Entity Model is created from the SQL Server database, sometimes the order of the fields for a given table is listed differently than in the database.  For example, in the database EmployeeID, EmployeeFirst, and EmployeeLast is the order for Employee table.  In the EDM, it may list EmployeeFirst, EmployeeID, and EmployeeLast.  Can this be changed in the EDM entity list to match the order of the database?

Hi,

you can easily achive this 

1)Open edmx file.

2)Click on Employe table

3)Right click on EmployeeFist. Click cut.

4)Click on EmployeID.Right click and paste.

5)This will place EmployeeFist after employeid.

6)Now right click on table and click table mappings.

7)you will find employefirst on left. and blank onright. select employefirst from dropdown on right.

Once you did this this will be play for you for 3 secods,

Mark this as answer if it helps you.

Hi,

Is above suggested methods solve your problem or you are still facing the problem?