How to execute the existing stored procedure with ASP.NET Core 3.1?

Question

There are some existing stored procedures and all I need to do is execute them with some parameters I tried some of the examples and all didn't work.

var result = new List<ExistingLoad>();
 
var clientIdParam = new SqlParameter("ClientId", clientId);
var clienteleIdParam = new SqlParameter("ClienteleId", clienteleId);
SqlParameter[] @params ={
    new SqlParameter("@result", SqlDbType.Xml) {Direction = ParameterDirection.Output}
};
 
var result2 = _cdsContext.Database.ExecuteSqlCommandAsync("[Load].[GetLoad] @ClientId, @ClienteleId, OUTPUT", clientIdParam, clienteleIdParam, @params);
var resultSet = @params[0].Value; 
var result3 = _cdsContext.Database.ExecuteSqlRaw("exec [Load].[GetLoad] @ClientId, @ClienteleId, OUTPUT", clientIdParam, clienteleIdParam, result);

question from:https://stackoverflow.com/questions/65880131/how-to-execute-the-existing-stored-procedure-with-asp-net-core-3-1

Answer 1

Waitting for answers