How to implement many to many relationship in Asp.Net Mvc ..

In Index() method of School controller, Which code need to write by me? Please, explain. I don't want to use fluent API. I want to implement it using Data Annotation.

In Model Folder, I have created Student.cs class

public class Student
{
public int StudentId { get; set; }
public string StudentName { get; set; }
public ICollection CoursesNProperty { get; set; }
}

In Model Folder, I have created Course.cs class

public class Course
{
public int CourseId { get; set; }
public string CourseName { get; set; }
public ICollection StudentsNProperty { get; set; }
}

In Model Folder, I have created SchoolContext.cs class

public class SchoolContext :DbContext
{
public SchoolContext() : base("name=conStr") { }
public DbSet Students { get; set; }
public DbSet Courses { get; set; }
}

In web.config file

<connectionStrings>
<add name="conStr" connectionString="Data Source=Dinesh\Aaradhya;Database=GopinathSchoolMToM;User Id=sa;Password=test123" providerName="System.Data.SqlClient"/>
connectionStrings>

In controller Folder, I have created School controller

using Note7Page124CascadeMToM.Models;
namespace Note7Page124CascadeMToM.Controllers
{
public class SchoolController : Controller
{
SchoolContext db = new SchoolContext();
// GET: School
public ActionResult Index()
{
Student student1 = new Student()
{
StudentName = "Prakash"
};
Student student2 = new Student()
{
StudentName = "Shubham"
};
Course course1 = new Course()
{
CourseName = "Asp.Net"
};
Course course2 = new Course()
{
CourseName="C#.Net"
};
//Which code need to implement here? ...
return View();
}
}
}

1 Reply

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

Jenith Thakkar8y ago
https://stackoverflow.com/questions/23071748/how-to-retrieve-data-from-many-to-many-relationship-from-the-controller-in-the-d

As per Above link you have to add both properties in one class and then using Include functionality you can the data of both entities