/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 vote193 views1 answer
Bitter foods examplews
C#
6 votes200 views2 answers
Unity rotate vector around point
C#Unity
1 vote184 views2 answers
Unity sort a list
C#Unity
1 vote183 views1 answer
Arcane
C#
1 vote182 views1 answer
Unity mesh showing Instance
C#Unity
2 votes182 views1 answer
Change dot net core web api routing
C#
0 vote175 views1 answer
How to specify order of test in c#
C#
1 vote179 views1 answer
The CodeDom provider type "Microsoft.CodeDom.Providers.DotNetCompilerPlatform.CSharpCodeProvider, Microsoft.CodeDom.Providers.DotNetCompilerPlatform, Version=2.0.1.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" could not be located.
C#
2 votes192 views1 answer
Unity rotate around pivot c#
C#Unity
0 vote198 views1 answer
How to make build events always run visual studio
C#