/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 vote125 views1 answer
Asp.net repeater get item index
C#
0 vote155 views1 answer
Make random alphabet in c#
C#
0 vote138 views1 answer
List view in unity
C#Unity
6 votes117 views6 answers
Rigidbody velocity
C#
0 vote192 views1 answer
How to start a webpage from a button c#
C#
29 votes108 views3 answers
Unity c# delay function
C#
1 vote116 views1 answer
Vb.net open file with default program
C#
1 vote115 views1 answer
Convert request.form to dictionary c#
C#
3 votes168 views1 answer
Unity c# on trigger enter with specific gameobject
C#Unity
0 vote167 views1 answer
Unity soundclip mix
C#Unity