编辑“︁C Sharp 存储过程调用”︁（章节）

== 高级主题 ==
=== 表值参数 ===
C#可以传递表值参数到存储过程：
<syntaxhighlight lang="csharp">
DataTable dt = new DataTable();
// 填充DataTable...

SqlParameter tvpParam = command.Parameters.AddWithValue("@EmployeeList", dt);
tvpParam.SqlDbType = SqlDbType.Structured;
tvpParam.TypeName = "dbo.EmployeeTableType";
</syntaxhighlight>

=== 异步编程 ===
使用async/await模式调用存储过程：
<syntaxhighlight lang="csharp">
public async Task<List<Employee>> GetEmployeesAsync()
{
    List<Employee> employees = new List<Employee>();
    
    using (SqlConnection connection = new SqlConnection(connectionString))
    {
        await connection.OpenAsync();
        
        using (SqlCommand command = new SqlCommand("usp_GetAllEmployees", connection))
        {
            command.CommandType = CommandType.StoredProcedure;
            
            using (SqlDataReader reader = await command.ExecuteReaderAsync())
            {
                while (await reader.ReadAsync())
                {
                    employees.Add(new Employee {
                        Id = reader.GetInt32(0),
                        Name = reader.GetString(1)
                    });
                }
            }
        }
    }
    
    return employees;
}
</syntaxhighlight>