SQL Server 2005 column not visible at asp.net mvc4 controller

Asked May 04 '13 at 08:06

Active May 04 '13 at 10:38

Viewed 139 times

I am using ASP.NET MVC4 and SQL Server 2005 to develop a web application. Everything is working fine but I got stuck at a point. I updated my table with a new column NO_Person and updated my .edmx file. That updated column is showing up in the .edmx designer page but when I am trying to access that field at controller side its not showing in pop suggestion window and getting error

table does not contain definition of field NO_Person

I updated my library.dll file and tried to rebuild my project, but getting same error.

Any suggestion please help.

edited May 04 '13 at 10:38

asked May 04 '13 at 08:06

Satendra Jindal

1,048
3
10
15

seems like the underlying classes generated by edmx is not getting updated or regenerated. – Amit Rai Sharma May 04 '13 at 08:44
Any suggestion what to do for this problem – Satendra Jindal May 04 '13 at 09:26
You can use Update Model Wizard which should take care of this. However there are few things you need to take care when updating it. Refer http://msdn.microsoft.com/en-us/library/cc716700.aspx – Amit Rai Sharma May 04 '13 at 10:53
i updated my model many times even i deleted the edmx file and reattached it but getting the same problem. – Satendra Jindal May 04 '13 at 11:46
I tried this on new ASP.NET project and i am getting updates from database but on my existing project not showing any update from database. – Satendra Jindal May 06 '13 at 05:37
Finally i solved this problem. The problem was in "EntityFramework" package in library part of project. i removed and install that package again and its working fine now. – Satendra Jindal May 07 '13 at 08:41
I am happy your issue have been resolved. thanks for posting the fix :) – Amit Rai Sharma May 07 '13 at 08:44

SQL Server 2005 column not visible at asp.net mvc4 controller

0 Answers0