/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 vote141 views1 answer
C# compare months
C#
-1 vote129 views1 answer
How to clear a dictionary in c#
C#
0 vote151 views1 answer
C# substring until character single
C#
6 votes143 views2 answers
Readonly vs const c#
C#
1 vote152 views1 answer
Group by ef core
C#
0 vote136 views1 answer
Windows 10 see how long a program has been running
C#
46 votes137 views6 answers
Unity C# random number
C#
7 votes146 views2 answers
Open link c#
C#
0 vote159 views1 answer
Vb.net remove last comma from string
C#
0 vote146 views1 answer
C# today, yesterday, last week, last month
C#