DbContextEntensions for Stored Procedure in Entity Framework Core

DbContextEntensions.cs

using System.Collections.Generic;
using System.Data;
using Microsoft.EntityFrameworkCore;

namespace RasuwaProfile.Repository.Extensions
{
    public static class DbContextEntensions
    {
        public static IEnumerable<Dictionary<string, object>> FromDynamicStoredProc(this DbContext dbContext, string name, Dictionary<string, object> parameters = null)
        {
            var results = new List<Dictionary<string, object>>();
            var dbConnection = dbContext.Database.GetDbConnection();
            
            using (var command = dbConnection.CreateCommand())
            {
                command.CommandText = name;
                command.CommandType = CommandType.StoredProcedure;

                if (parameters != null)
                {
                    foreach (var key in parameters.Keys)
                    {
                        var parameter = command.CreateParameter();
                        parameter.ParameterName = "@" + key;
                        parameter.Value = parameters[key];
                        command.Parameters.Add(parameter);
                    }
                }
                    
                dbContext.Database.OpenConnection();
                using (var reader = command.ExecuteReader())
                while (reader.Read())
                {
                    var row = new Dictionary<string, object>();
                    for (var i = 0; i < reader.FieldCount; i++)
                        row[reader.GetName(i)] = reader.GetValue(i);
                    
                    results.Add(row);
                }
                
            }

            return results;

        } 
    }
}