/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 vote279 views1 answer
How to mirror an image in vs forms
C#
0 vote264 views1 answer
Mouselook script unity
C#
2 votes308 views1 answer
How to change the position of a gameobject in c# unity
C#Unity
1 vote287 views1 answer
Unity list of gameobjects
C#
2 votes264 views1 answer
C# how does comparing datetime work
C#
0 vote281 views1 answer
Ado stands for
C#
0 vote335 views1 answer
Mouselook script unity
C#Unity
1 vote325 views1 answer
How to open any file on button click in winforms
C#
0 vote282 views1 answer
Register all services microsoft .net core dependency injection container
C#
0 vote304 views2 answers
Run a command line from vb.net app
C#