Breaking News: Grepper is joining You.com. Read the official announcement!

Entity Framework Core 3.1 Return value (int) from stored procedure

Haze answered on October 15, 2021 Popularity 6/10 Helpfulness 5/10

answer Entity Framework Core 3.1 Return value (int) from stored procedure

Entity Framework Core 3.1 Return value (int) from stored procedure

Comment

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");
}

Popularity 6/10 Helpfulness 5/10 Language csharp

Source: stackoverflow.com

Tags: c# core entity-framework procedure return-value

Link to this answer
Share Copy Link