/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 vote146 views1 answer
C# string contains any of list
C#
1 vote147 views1 answer
Check valid binary search tree
C#
5 votes147 views1 answer
Check if string is email c#
C#
2 votes140 views1 answer
C# display attribute date
C#
0 vote142 views1 answer
The underlying connection was closed nuget
C#
10 votes190 views1 answer
Unity check if key pressed
C#Unity
0 vote126 views1 answer
Dotnet DB context register
C#
0 vote212 views1 answer
How to set picturebox width with form width in c#
C#
19 votes134 views6 answers
Bootstrap popup
C#
0 vote148 views1 answer
Attribute c# get method name reflection
C#