/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

2 votes331 views2 answers
Remove items from list c# condition
C#
1 vote316 views2 answers
Linq unique count
C#
0 vote352 views1 answer
The terminal process failed to launch: Path to shell executable "dotnet" is not a file or a symlink.
C#
4 votes343 views2 answers
Selenium c# maximize window
C#
0 vote340 views1 answer
Get Mac address of Device in Xamarin
C#
0 vote317 views1 answer
Asp net img src path from database
C#
0 vote347 views1 answer
PUN 2 Network Transform View Jittery Movement
C#
-1 vote383 views1 answer
How to create a random vector2 in unity
C#Unity
3 votes321 views5 answers
Converting bitmap to byte array c#
C#
0 vote383 views1 answer
Generate random dark colors programatically in android
C#