Having a stored procedure which returns list of Students with each user having list of projects
Execute the Stored procedure and receive the Students with their Projects from .Net
List<Student> students = ...................
public class Student { public int StudentId { get; set; } public string StudentName{ get; set; } public List<Project> Projects { get; set;} }
public class Project { public int ProjectId { get; set; } public string ProjectName { get; set; } }