forum

Home / DeveloperSection / Forums / Database not working after updating the table in Visual studio 2012

Database not working after updating the table in Visual studio 2012

Simond Gear190825-Mar-2016

Hi All,

I have getting error after updating tables directly in sql server 2012, it will through error in my MVC application. Error is below:

Server Error in '/' Application. Invalid column name 'Id'. Invalid column name 'Id'.

Here, My Table is below:

CREATE TABLE [dbo].[Course](
       [ID] [int] IDENTITY(1,1) NOT NULL,
       [Title] [nvarchar](50) NULL,
       [Credits] [int] NOT NULL,
       [DepartmentID] [int] NOT NULL,
 CONSTRAINT [PK_dbo.Course] PRIMARY KEY CLUSTERED
(
       [ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

Please can anyone help.

Thank you.

c# asp.net database asp.net mvc entity framework

Updated on 25-Mar-2016