/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 vote124 views2 answers
C# traverseall elements in class property
C#
0 vote119 views1 answer
G2
C#
0 vote111 views1 answer
Declare multiple variables in for loop c#
C#
0 vote119 views1 answer
Get all classes that extend a class c#
C#
9 votes132 views2 answers
Push c# array
C#
10 votes84 views1 answer
Unity initialize prefab
C#
0 vote167 views1 answer
Get datacontext of itemscontrol item c#
C#
1 vote133 views1 answer
Unity get a position inside sphere
C#Unity
2 votes124 views1 answer
Ef Select 2 from DB
C#
0 vote120 views1 answer
Get attribute value of xml element c#
C#