/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

3 votes358 views1 answer
How to get the transform of an object in unity
C#Unity
0 vote362 views1 answer
Set file to read only C#
C#
1 vote335 views1 answer
In Asp.Net Core core how to I get the web site's IP address?
C#
1 vote370 views2 answers
C# get first and last day of current month
C#
5 votes321 views2 answers
How to exit application c# console
C#
2 votes385 views1 answer
How to reference scripts in other scenes unity
C#Unity
0 vote389 views1 answer
Unity iap
C#Unity
3 votes331 views3 answers
C# retrieve files in folder
C#
0 vote328 views1 answer
Reverse for loop unity
C#
1 vote346 views1 answer
Http error 502.5 asp.net core 2.2
C#