/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 votes355 views2 answers
Dotween sequence
C#
0 vote303 views1 answer
Unity respawn c#
C#
2 votes329 views3 answers
Function in c#
C#
1 vote360 views2 answers
C# memorystream to byte array
C#
0 vote299 views1 answer
C# system cryptography hash string
C#
1 vote343 views1 answer
Chrome clear console history
C#
6 votes340 views2 answers
C# read all files in a directory
C#
2 votes300 views6 answers
Or operator in c#
C#
4 votes427 views1 answer
Unity spherecast
C#Unity
11 votes330 views3 answers
C sharp list of strings
C#