get list of data from database using stored procedure

Question

I want to get the list of data from the database as student each student has list of projects

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; }
}

Jaimin Shethiya · Answer

Hello, In your example the relationship is not there, so you need to first do the relationship then after create the store procedure to get the combine data. Thanks

Tahir Ansari · Answer

CREATE PROCEDURE GetStudentsWithProjects AS BEGIN SELECT s.StudentId, s.StudentName, p.ProjectId, p.ProjectName FROM Students s INNER JOIN Projects p ON s.StudentId = p.StudentId END using System; using System.Linq; class Program { static void Main(string[] args) { using (var context = new YourDbContext()) { var studentsWithProjects = context.Students .FromSqlRaw("EXEC dbo.GetStudentsWithProjects") // Assuming "GetStudentsWithProjects" is your stored procedure name .ToList(); foreach (var student in studentsWithProjects) { Console.WriteLine($"Student ID: {student.StudentId}, Name: {student.StudentName}"); foreach (var project in student.Projects) { Console.WriteLine($" Project ID: {project.ProjectId}, Name: {project.ProjectName}"); } } } } }

get list of data from database using stored procedure

Answers (2)