/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 vote188 views1 answer
Linked list follow what in c#
C#
8 votes177 views2 answers
C# add object to array
C#
0 vote181 views1 answer
How to check type c#
C#
1 vote201 views2 answers
C vs c
C#
0 vote169 views1 answer
Unity switch to scene and transfer data
C#
3 votes179 views1 answer
How consider the first caracter in Split c#
C#
0 vote196 views1 answer
Chrome devtools capture all styling an element uses
C#
8 votes182 views2 answers
Unity pause game
C#Unity
7 votes172 views2 answers
How to instantiate as child unity
C#
0 vote185 views1 answer
Unity NetworkBehaviour the type or namespace could not be found
C#