/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 vote241 views1 answer
Unity change particle system sorting layer via script
C#Unity
0 vote218 views1 answer
Get ad user using email address microsoft graph C#
C#
1 vote221 views1 answer
C# add time to datetime
C#
2 votes212 views1 answer
Ef select multiple items
C#
10 votes195 views2 answers
C# string contains
C#
1 vote207 views1 answer
Hos to make slider in editor unity
C#
1 vote226 views1 answer
Using serial port in c#
C#
14 votes238 views1 answer
Unity string split
C#Unity
1 vote203 views2 answers
Huidige timestamp c#
C#
0 vote206 views1 answer
String in char list f#
C#