I have two tables like below Table_ID Course_Category_ID Course_Category_NAme 1 1 Basic Sciences and The Course Main Table in which this category ID would be a foreign key Table_ID Course_Category_ID(F) Course_ID Course_Name 1 1 1 Math 2 1 2 Physics how to write a model class where course category_ID is foreign key

Hi Ravishankar i am getting this error while adding a new controller with read write actionsa and views

[Display(Name = "Course Category")] [ForeignKey("Course_Category")] public virtual Courses_Category course_category { get; set; } public int Course_Category { get; set; } is that not write way which i did it is for courses category as foreign key in courses table

Hi Mark, I hope this below example will be helpful, public class Course { [Key] public int Table_ID { get; set; } [ForeignKey( "Course_Category_ID" )] public Course_Category_ID Course_Category_ID{ get; set; } }

Answers

How to map the foreign key in my model class using MVC

Mark Tabor

928

1 .NET

I have two tables like below

Table_ID	Course_Category_ID	Course_Category_NAme
1	1	Basic Sciences

and The Course Main Table in which this category ID would be a foreign key

Table_ID	Course_Category_ID(F)	Course_ID	Course_Name
1	1	1	Math
2	1	2	Physics

how to write a model class where course category_ID is foreign key

How to map the foreign key in my model class using MVC

Insert Link

Embed YouTube Video

Table Options

Insert Image

Answers (3)