/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 vote261 views1 answer
Unity c# struct
C#Unity
0 vote240 views1 answer
How to get day name from datetimepicker in c#
C#
0 vote236 views1 answer
C# get process file location
C#
0 vote241 views1 answer
C# hashtable get value by key
C#
0 vote280 views1 answer
Unity how to check index of enum
C#
1 vote238 views1 answer
Unity getcomponent not working on ui
C#
0 vote271 views1 answer
Convert object to iqueryable in c#
C#
0 vote211 views1 answer
Microsoft forms create bitmap
C#
0 vote248 views1 answer
C# devexpress get foucused dataRow of child gridView
C#
0 vote289 views1 answer
Make random alphabet in c#
C#