/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 vote327 views1 answer
Get all devices connected using player input manager unity
C#
0 vote346 views1 answer
C# check if value in dictionary are unique
C#
33 votes329 views2 answers
How to instantiate a gameobject
C#
6 votes332 views1 answer
How to change a image with code unity
C#
41 votes331 views6 answers
Samsung sam
C#
0 vote335 views1 answer
Angular === vs ==
C#
2 votes313 views1 answer
Unity overlapsphere
C#
0 vote364 views1 answer
Big sorting hackerrank solution in C#
C#
0 vote313 views1 answer
Git rm
C#
1 vote332 views1 answer
Update multiple records with entity framework
C#