Invalid column name ‘Course_Tags’. in razor View

Question

Hi I am having a mvc web application in which I have four tables and i am using below linq query to get all columns from all tables and i inspect it using debugging it is getting all data from all four tables , var dept = from s in db.Teacher_courses join ce in db.Courses on s.CourseId equals ce.Course_Id join se in db.Semesters on s.Semester_Id equals se.Semester_Id join re in db.Registration on s.Teacher_Id equals re.User_Id where ce.Course_Id == s.CourseId select s; I have below Model class previously i was only getting data from Teacher_Courses Table but now I need to add more columns like semester,Registration and Courses table , so for experiment I just wrote the above query and inpect it using debugging it is getting all fields values from all tables , so I add one more property to my model class for Courses_TAGS as shown below and i am using it in my view as shown below @Html.DisplayFor(modelItem => item.regs.FullName) @Html.DisplayFor(modelItem => item.Course_Tags) but i am getting this below error message

Jignesh Kumar · Answer

Hi Mark, Please check your linq query result you are getting that coulmn in your linq query while returning result from controller to view. Please shre you model and view which model you are refering there and contoller action method where you are returing your result.

Piyush Pansuriya · Answer

Hi, Which approch you are working with? Code first or Database First ? If code first you have to migrate the database by using entity framework or If database first you have to add column into database table "Course_Tags" . Inshort "Course_Tags" column have to add in database table. It is missing.

Suraj Kumar · Answer

Your code should look like this. td > @Html.DisplayFor( modelItem = > modelItem.Course_Tags) td >

Mark Tabor · Answer

Course_Tag column is present in Courses Table but not in main TEACHERVSCOURSES TABLE, as you can see the linq query it is getting the courses TAG information as well About the Approach I am using Classes as models having same name as table Name in database and I put the TABLE annotation attribute for each model as well

Rupesh Kahane · Answer

Can you plese check whether the Course_Tags field is initialized or not, after creating object of model plz check wheather not null, empty etc & if possible assing the value