/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

0 vote129 views3 answers
Change physics material unity
C#Unity
1 vote122 views1 answer
Using serial port in c#
C#
0 vote127 views1 answer
Unity predicts rigidbody position in x seconds
C#Unity
47 votes170 views6 answers
C# print console
C#
3 votes126 views2 answers
C# image to byte array
C#
0 vote104 views1 answer
C# isalphanumeric
C#
0 vote96 views1 answer
Linq query in c# to select all
C#
0 vote113 views1 answer
How to add rigidbody as a variable
C#
16 votes111 views10 answers
How to code
C#
11 votes143 views3 answers
How to remove all whitespace from a string in c#
C#