/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

20 votes121 views4 answers
JSONStringify c#
C#
2 votes124 views1 answer
Change fog setting Unity
C#
1 vote131 views1 answer
Randomize through array in C#
C#
2 votes184 views1 answer
How to remove space between string in c#
C#
0 vote158 views1 answer
C# changimg to one decimal place
C#
2 votes168 views1 answer
Find closest gameobject unity
C#Unity
0 vote125 views1 answer
Unity stop all audio
C#
0 vote139 views1 answer
How to detect when a gameobject has exited a trigger c#
C#
1 vote161 views1 answer
Unity C# catch index out or range exception
C#
0 vote134 views1 answer
Isselected uicollectionview reused
C#