/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 vote87 views1 answer
Map Range Clamped unity
C#
0 vote91 views1 answer
Six simple machines labeled
C#
0 vote95 views1 answer
Print bitmap company logo c sharp
C#
1 vote95 views1 answer
C# monogame mouse position
C#
0 vote91 views1 answer
Is keyboard clicked in Unity
C#
21 votes140 views2 answers
Random.range unity
C#Unity
1 vote136 views1 answer
Change size of a unity object
C#Unity
121 votes235 views6 answers
Generate a random number in c#
C#
0 vote95 views1 answer
How to populate a collection c#
C#
1 vote137 views1 answer
Struct constructor c#
C#