/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 vote107 views1 answer
Find word in string array c#
C#
5 votes106 views3 answers
C# exit foreach
C#
0 vote103 views1 answer
C# return task list
C#
0 vote126 views3 answers
JAJAAJAJAJ
C#
0 vote117 views1 answer
Unity apply bloom of a different color
C#
1 vote100 views1 answer
.net: setting max size for sql parameter
C#
0 vote84 views1 answer
AutoFixture ignore property
C#
1 vote116 views2 answers
C# find duplicates in list of strings
C#
16 votes79 views1 answer
For loop on enum c#
C#
1 vote146 views1 answer
Remove repeated items in a list unity
C#Unity