/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 vote277 views1 answer
Disable quickedit c#
C#
1 vote260 views1 answer
C# .net core convert string to enum
C#
-1 vote250 views1 answer
How to update model when database change in entity framework core
C#
0 vote272 views1 answer
Transformar de string a int c#
C#
4 votes256 views1 answer
Create list with values C#
C#
-1 vote246 views1 answer
Unity audio source playoneshot
C#
41 votes255 views6 answers
Samsung sam
C#
4 votes306 views1 answer
Unity get velocity of gameobject
C#Unity
3 votes275 views2 answers
Webclient c# example post
C#
12 votes245 views6 answers
Ternary operator c#
C#