/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 vote137 views1 answer
How can datetimepicker accept hour as well
C#
53 votes121 views6 answers
Print in c#
C#
1 vote163 views1 answer
Make mesh follow wheel collider unity
C#Unity
1 vote125 views1 answer
Linq c# where condition
C#
11 votes136 views4 answers
Loop through string array c#
C#
0 vote133 views2 answers
Change object material unity
C#
0 vote146 views1 answer
Telerik raddatepicker default date today wpf
C#
1 vote127 views1 answer
How to create a string in c#
C#
1 vote140 views1 answer
How to change the axis of a Vector3 variable
C#
0 vote120 views1 answer
Delay seconds in unity
C#