/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

10 votes177 views5 answers
C# null check
C#
13 votes151 views4 answers
C# how to sort a list
C#
1 vote143 views2 answers
C# for
C#
8 votes150 views2 answers
Sum in c#
C#
0 vote150 views1 answer
Crop bitmap image c#
C#
-1 vote162 views2 answers
Double quotes in a string c#
C#
0 vote151 views2 answers
Array of array
C#
2 votes235 views1 answer
Unity return coroutine
C#Unity
0 vote145 views1 answer
Razor concatonate inline
C#
3 votes154 views1 answer
Unity detect any key
C#