/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 vote204 views1 answer
Remove numericUpDown white space
C#
0 vote183 views1 answer
Hello world in unity c#
C#
0 vote201 views1 answer
Params string[]
C#
0 vote231 views1 answer
Lightbox
C#
0 vote187 views1 answer
This site can’t be reachedlocalhost unexpectedly closed the connection. .net framework
C#
1 vote192 views2 answers
For statement syntax C sharp
C#
0 vote174 views1 answer
Swagger skip endpoint .net core
C#
0 vote224 views1 answer
How to get user browser information in .net core
C#
3 votes185 views2 answers
C# get type of class
C#
0 vote193 views1 answer
C# split on multiple characters
C#