/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

6 votes269 views2 answers
Unity check collider layer
C#
0 vote294 views1 answer
How to make projectile track and go to specified enemy in unity
C#
0 vote278 views1 answer
Wpf listboxitem event command
C#
0 vote282 views1 answer
C# MemoryStream - Timeouts are not supported on this stream
C#
-1 vote262 views1 answer
How to update model in entity framework db first approach
C#
1 vote282 views1 answer
GGdesign
C#
0 vote278 views1 answer
How to select class object from query c#
C#
0 vote248 views1 answer
Unity ar scale
C#Unity
0 vote270 views1 answer
Adb get android version
C#
12 votes295 views2 answers
Doing void when gameobject setactive unity
C#