/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 vote153 views1 answer
How to move an object flush in unity
C#
1 vote176 views1 answer
C# winforms textbox text color
C#
0 vote151 views1 answer
Render section asp.net mvc layout
C#
0 vote201 views1 answer
C# words return first 20 items of array
C#
3 votes194 views1 answer
C# center text
C#
2 votes211 views1 answer
C# convert to snake case
C#
2 votes233 views1 answer
How to check the tag of a collider in unity
C#Unity
3 votes217 views1 answer
Invoke once on update unity
C#Unity
0 vote130 views1 answer
Report background worker
C#
0 vote162 views1 answer
Arabic lorem ipsum
C#