如何将多个参数编程为SQL Server存储过程的代码

CREATE PROCEDURE GetEmployeeById
    @EmployeeId INT,
    @DepartmentId INT
AS
BEGIN
    SELECT * FROM Employees
    WHERE EmployeeId = @EmployeeId AND DepartmentId = @DepartmentId;
END

using System;
using System.Data;
using System.Data.SqlClient;

class Program
{
    static void Main()
    {
        string connectionString = "your_connection_string_here";
        int employeeId = 1;
        int departmentId = 1;

        using (SqlConnection connection = new SqlConnection(connectionString))
        {
            connection.Open();

            SqlCommand command = new SqlCommand("GetEmployeeById", connection);
            command.CommandType = CommandType.StoredProcedure;
            command.Parameters.AddWithValue("@EmployeeId", employeeId);
            command.Parameters.AddWithValue("@DepartmentId", departmentId);

            SqlDataReader reader = command.ExecuteReader();

            while (reader.Read())
            {
                Console.WriteLine($"Employee ID: {reader["EmployeeId"]}, Department ID: {reader["DepartmentId"]}");
            }

            reader.Close();
        }
    }
}