/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 vote240 views1 answer
How to check if the value is alphabet and numbers only only in c#
C#
0 vote211 views1 answer
Distinct and not null c#
C#
0 vote208 views1 answer
C# param exception
C#
0 vote222 views1 answer
Circle button android
C#
0 vote221 views1 answer
C# alphabetize a list of string
C#
0 vote223 views1 answer
Faire des séparateurs millers en c#
C#
11 votes214 views3 answers
Enum get all values C#
C#
39 votes222 views3 answers
C# dictionary loop key value
C#
0 vote222 views1 answer
Unity OVR Headset Emulator not working
C#
0 vote207 views2 answers
Round to int 32 c#
C#