/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 vote105 views1 answer
Subtract two times c#
C#
32 votes170 views6 answers
Unity enable and disable gameobject
C#Unity
3 votes112 views6 answers
C# while loop
C#
11 votes98 views1 answer
How to copy last element in list c#
C#
4 votes101 views2 answers
C# delete files older than 10 days
C#
0 vote101 views1 answer
Update browserslist
C#
-1 vote102 views1 answer
Unity check if colliders are touching
C#
0 vote99 views1 answer
.net return result encoding as utf8
C#
0 vote96 views2 answers
C# check file similarities
C#
-1 vote63 views1 answer
C# resize image from byte array
C#