/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

4 votes286 views3 answers
Regular expression for email in c#
C#
2 votes293 views2 answers
C# csv read write
C#
2 votes277 views1 answer
C# print out whole object
C#
0 vote295 views1 answer
Remove loading bars devexpress on callback
C#
12 votes324 views2 answers
Doing void when gameobject setactive unity
C#
0 vote301 views1 answer
Install Mono project on Ubuntu 20.04
C#
1 vote356 views1 answer
Reference to another script unity
C#Unity
0 vote308 views1 answer
C# iorderedenumerable to dictionary
C#
4 votes331 views1 answer
Unity cast int to float
C#Unity
1 vote340 views1 answer
Unity editor script fill a scriptableobject serialized field
C#Unity