什么是数据库的存储过程异步执行？在C#中如何实现？

using System;
using System.Data;
using System.Data.SqlClient;
using System.Threading.Tasks;

public class StoredProcedureService
{
    private readonly string _connectionString = "Server=.;Database=TestDB;Integrated Security=true;";

    public async Task<DataTable> ExecuteStoredProcedureAsync(string procedureName, SqlParameter[] parameters = null)
    {
        using (var connection = new SqlConnection(_connectionString))
        {
            await connection.OpenAsync();

            using (var command = new SqlCommand(procedureName, connection))
            {
                command.CommandType = CommandType.StoredProcedure;

                // 添加参数（如果有）
                if (parameters != null)
                {
                    command.Parameters.AddRange(parameters);
                }

                using (var reader = await command.ExecuteReaderAsync())
                {
                    var dataTable = new DataTable();
                    dataTable.Load(reader);
                    return dataTable;
                }
            }
        }
    }
}

// 假设有一个名为 GetUserById 的存储过程
var service = new StoredProcedureService();

var param = new SqlParameter("@UserId", 123);

try
{
    var result = await service.ExecuteStoredProcedureAsync("GetUserById", new[] { param });

    foreach (DataRow row in result.Rows)
    {
        Console.WriteLine($"Name: {row["Name"]}, Email: {row["Email"]}");
    }
}
catch (Exception ex)
{
    Console.WriteLine($"Error: {ex.Message}");
}

var result = await context.Users
    .FromSqlRaw("EXEC GetUsersByRole @role", parameter)
    .ToListAsync();