/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 vote175 views1 answer
Get last element in a list vb.net
C#
0 vote171 views1 answer
C# start file
C#
0 vote162 views1 answer
Windows 10 see how long a program has been running
C#
0 vote160 views1 answer
Guicontrol text ahk
C#
0 vote164 views1 answer
Collection to datatable c#
C#
0 vote255 views1 answer
'Using a Hub instance not created by the HubPipeline is unsupported.'
C#
13 votes245 views3 answers
C# join array
C#
1 vote175 views1 answer
Create a slider in the inspector C#
C#
0 vote170 views1 answer
How to change the volume of all sound effects in monogame
C#
20 votes219 views2 answers
Change scale of an object unity
C#Unity