/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

1 vote237 views1 answer
Check valid binary search tree c#
C#
0 vote254 views1 answer
C# how to start an application and detect if started
C#
4 votes242 views2 answers
Get text unity
C#
0 vote274 views1 answer
Exception e is null c#
C#
0 vote295 views1 answer
Unity set list of strings
C#Unity
11 votes275 views4 answers
C# check if array contains value
C#
0 vote259 views1 answer
How to turn camera space to world space unity
C#
0 vote282 views1 answer
Unity iap
C#Unity
-3 votes226 views1 answer
How to split a string by in c#
C#
0 vote269 views1 answer
Embed video to exe file with c#
C#