get list of data from database using stored procedure

Gopi

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 Projects { get; set;}
}

public class Project
{
public int ProjectId { get; set; }
public string ProjectName { get; set; }
}

2 Replies

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

Jaimin Shethiya2y ago
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 Ansari2y ago

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