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

838

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

Answers (3)

Next Recommended Forum

Online registration for booking and register users

Advice about best method

Forum Statistics

Please welcome our newest member Pedro Castro.
3,084,024 users have contributed to 147,418 threads and 483,477
In the past 24 hours, we have 14 new threads, 39 new posts, and 92 new users.
In last week, the most popular thread is 'How to "C# Corner"'.

Upcoming Events

View all

Global Azure Bootcamp - Rasipuram
Software Architecture Conference - 2025