Calling Stored Procedures in EF Core

await _context.Database.ExecuteSqlCommandAsync(
    $"EXEC MySproc @ID={DbNull.Value}", cancellationToken);

await _context.Database.ExecuteSqlCommandAsync(
    $"EXEC MySproc @ID={null}", cancellationToken);

var parameters = new List<SqlParameter>
{
    new SqlParameter("@Id", SqlDbType.UniqueIdentifier) { Value = DBNull.Value })
};

await _context.Database.ExecuteSqlCommandAsync($"EXEC MySproc @Id",
parameters,
cancellationToken);

var requestUidOutputParam = new SqlParameter("@RequestUID", SqlDbType.UniqueIdentifier) { Direction = ParameterDirection.Output };

// EF Core requires that all stored procedure parameters are sent (even defaulted ones) if we want to use output parameters
var priceItems = await _context.PricingItems
    .FromSql("PriceItems @AccountID, @RequestUID OUTPUT, @PriceItems, @ServiceID",
        new SqlParameter("@AccountID", SqlDbType.Int) { Value = DBNull.Value },
        new SqlParameter("@PriceItems", SqlDbType.Structured) { TypeName = "PWB_TT_PriceItems_V4", Value = BuildEmptyPriceItemTableType() },
        new SqlParameter("@ServiceID", serviceId))
    .AsNoTracking()
    .ToListAsync(cancellationToken);

if (!Guid.TryParse(requestUidOutputParam.Value?.ToString(), out var requestUid))
{
    throw new ArgumentException("error converting RequestUID");
}