/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 vote160 views1 answer
C# unity control key input
C#
4 votes165 views3 answers
Sum of digit of number c#
C#
3 votes159 views1 answer
Using variables from other procedures C#
C#
0 vote155 views1 answer
Divide string in chunks c#
C#
0 vote159 views2 answers
Get after point in c#
C#
0 vote168 views1 answer
Convert number of days into months c#
C#
-2 votes1.5K views1 answer
How to reference a static variable from another script in unity
C#Unity
25 votes206 views4 answers
Unity movetowards
C#
0 vote150 views1 answer
How do you make a 2D object follow another 2D object in unity 2D
C#
0 vote169 views1 answer
Autoclicker for yes/no in c# indicator
C#