/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 vote127 views1 answer
Init stirng list c#
C#
1 vote160 views1 answer
Socket io connect to namespace
C#
11 votes128 views1 answer
Abril modal boostrap
C#
0 vote135 views1 answer
Update postgres sequence to max
C#
0 vote100 views1 answer
C# class reference
C#
14 votes142 views4 answers
One line condition c#
C#
0 vote132 views1 answer
Wpf binding object get value
C#
1 vote134 views1 answer
C# start as adminstrator
C#
0 vote137 views2 answers
Append multi lines to file linux
C#
2 votes194 views1 answer
Unity c# set object tag
C#Unity