/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 votes124 views4 answers
The request was aborted: Could not create SSL/TLS secure channel.
C#
0 vote140 views1 answer
Godot Duplicate 'global::System.Runtime.Versioning.TargetFrameworkAttribute'
C#
0 vote151 views1 answer
Get child of transform by index unity
C#Unity
25 votes192 views4 answers
Unity movetowards
C#Unity
0 vote90 views1 answer
For i in enumerate(3
C#
3 votes143 views1 answer
C# loop array backwards
C#
0 vote131 views1 answer
Wpf label content nullpointerexception
C#
0 vote134 views1 answer
Print arraylist values to console unity
C#Unity
26 votes118 views4 answers
Unity print
C#
1 vote125 views2 answers
Unique items in list c#
C#