如何从连接3个表并采用3个不同参数的asp.net MVC的存储过程中获取数据

CREATE PROCEDURE GetCombinedData
    @Param1 INT,
    @Param2 INT,
    @Param3 INT
AS
BEGIN
    SELECT *
    FROM Table1 t1
    INNER JOIN Table2 t2 ON t1.Id = t2.Table1Id
    INNER JOIN Table3 t3 ON t2.Id = t3.Table2Id
    WHERE t1.Column1 = @Param1
    AND t2.Column2 = @Param2
    AND t3.Column3 = @Param3
END

public ActionResult GetData(int param1, int param2, int param3)
{
    List<DataModel> data = new List<DataModel>();

    using (SqlConnection connection = new SqlConnection(connectionString))
    {
        SqlCommand command = new SqlCommand("GetCombinedData", connection);
        command.CommandType = CommandType.StoredProcedure;

        command.Parameters.AddWithValue("@Param1", param1);
        command.Parameters.AddWithValue("@Param2", param2);
        command.Parameters.AddWithValue("@Param3", param3);

        connection.Open();

        SqlDataReader reader = command.ExecuteReader();

        while (reader.Read())
        {
            DataModel model = new DataModel();
            // 从reader中读取数据并填充到model中
            // model.Property1 = reader["Column1"];
            // model.Property2 = reader["Column2"];
            // ...

            data.Add(model);
        }

        reader.Close();
    }

    return View(data);
}