How to execute stored procedure in ASP.NET Core 3.1 and assign result

Using ADO.NET, you can achieve the same as the below. You may need to update this script depends on your use case

using System;
using System.Data;
using System.Data.SqlClient;

namespace StoredProcedureExample
{
    class Program
    {
        static void Main(string[] args)
        {
            string connectionString = "your_connection_string_here";

            using (SqlConnection connection = new SqlConnection(connectionString))
            {
                connection.Open();

                using (SqlCommand command = new SqlCommand("YourStoredProcedureName", connection))
                {
                    command.CommandType = CommandType.StoredProcedure;

                    command.Parameters.AddWithValue("@startdate", yourStartDateValue);
                    command.Parameters.AddWithValue("@enddate", yourEndDateValue);

                    using (SqlDataReader reader = command.ExecuteReader())
                    {
                        // Read the first result set
                        while (reader.Read())
                        {
                            int caseID = (int)reader["CaseID"];
                            string caseName = reader["CaseName"].ToString();

                            // Process caseID and caseName
                        }

                        // Move to the next result set
                        reader.NextResult();

                        // Read the second result set
                        while (reader.Read())
                        {
                            string firstName = reader["FirstName"].ToString();
                            string lastName = reader["LastName"].ToString();
                            string designation = reader["Designation"].ToString();

                            // Process firstName, lastName, and designation
                        }

                        // Move to the next result set
                        reader.NextResult();

                        // Read the third result set
                        while (reader.Read())
                        {
                            string returnValue = reader["ReturnValue"].ToString();

                            // Process returnValue
                        }
                    }
                }
            }
        }
    }
}