/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 vote289 views1 answer
Asp.net list find
C#
0 vote253 views1 answer
C# how to group console output into columns
C#
0 vote338 views1 answer
Missing integer c#
C#
5 votes285 views6 answers
Shuffle array c#
C#
16 votes274 views1 answer
Movement script c#
C#
0 vote310 views1 answer
Hello world in unity c#
C#Unity
0 vote309 views1 answer
Can't select ui in scene view unity
C#Unity
0 vote270 views1 answer
.net mvc decimal displayformat currency
C#
1 vote271 views1 answer
Float parse c#
C#
10 votes294 views10 answers
FORTNITe
C#