Invalid column name ‘Course_Tags’. in razor View

Mark Tabor

6y1.5k.NET

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

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Suraj Kumar6y ago
Your code should look like this.
<td>@Html.DisplayFor(modelItem => modelItem.Course_Tags)td>
Jignesh Kumar6y ago
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.
Mark Tabor6y ago
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
Piyush Pansuriya6y ago
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.
Rupesh Kahane6y ago
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