/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 vote302 views2 answers
C sharp type in word and calculate how much a letter is inside that word
C#
0 vote315 views2 answers
Blazor onchange event not firing with inputselect
C#
1 vote318 views1 answer
How to display doubles with trailing zeros in c#
C#
1 vote288 views1 answer
Request.ServerVariables["HTTP_X_FORWARDED_FOR"] get only one ipaddress
C#
0 vote288 views1 answer
How to do Employing defensive code in the UI to ensure that the current frame is the most top level window in c#
C#
0 vote340 views1 answer
C# int cast error
C#
1 vote299 views4 answers
C# timestamp now
C#
0 vote362 views3 answers
Count number of specific characters in string c#
C#
0 vote256 views1 answer
C# windows forms how to get controls in gropu box
C#
0 vote277 views1 answer
C# get every point in a line in matrix
C#