/C#/Entity Framework Core 3.1 Return value (int) from stored procedure

Entity Framework Core 3.1 Return value (int) from stored procedure

int? quantity = 0;
var ticketParam = new SqlParameter("Ticket", ticket);
var referenceParam = new SqlParameter("Reference", reference);
var quantityParam = new SqlParameter("Quantity") { Direction = ParameterDirection.Output };
try
{
    await _context.Database.ExecuteSqlRawAsync("EXEC Production.Select_TicketQuantity @Ticket, @Reference, @Quantity output", new[] { ticketParam, referenceParam, quantityParam });
    quantity = Convert.ToInt32(quantityParam.Value);
}
catch (Exception ex)
{
    _logger.LogError($"{ex}");
    return RedirectToPage("Index");
}

Source: stackoverflow.com

Similar codes

0 vote311 views1 answer
C# check if value in dictionary are unique
C#
0 vote322 views1 answer
C# datareader already open visual studio mysql
C#
0 vote295 views1 answer
C# place all keys in dictionary into array
C#
0 vote314 views1 answer
Convert rgb to float
C#
0 vote313 views1 answer
C# cosmos db add items into container
C#
0 vote341 views1 answer
Httpcontext.current.session null c# in class library
C#
0 vote375 views2 answers
Remove all non alphabetic characters from string c#
C#
0 vote311 views1 answer
C# return list in descending order
C#
0 vote348 views1 answer
LINQ query to select top 5
C#
0 vote301 views1 answer
C# how-to-download-image-from-url
C#