带参数的SqlCommand如何工作？

public string InsertStudent(Student student)
{
    string message = "";
    SqlConnection connection = new SqlConnection(connectionString);

    string query = "insert into Students values(@regNo, @name, @email, @departmentId)";

    SqlCommand command = new SqlCommand(query, connection);
    command.Parameters.Clear();

    command.Parameters.Add("regNo", SqlDbType.VarChar, 50).Value = student.RegNo;

    //////////////////or//////////////
    command.Parameters.Add("name", SqlDbType.VarChar);
    command.Parameters["name"].Value = student.Name;

    command.Parameters.Add("email", SqlDbType.VarChar);
    command.Parameters["email"].Value = student.Email;

    command.Parameters.Add("departmentId", SqlDbType.Int);
    command.Parameters["departmentId"].Value = student.DepartmentId;

    connection.Open();
    int rowAffected = command.ExecuteNonQuery();
    connection.Close();
}

My question: when I write

我的问题：我写的时候

command.ExecuteNonQuery()

要么

command.ExecuteReader()

how command reference find out the references or memory locations of newly created SqlParameter objects?

命令参考如何找出新创建的SqlParameter对象的引用或内存位置？

May you draw pictures of references of these objects and their relations in heap memory and stack memory?

你可以在堆内存和堆栈内存中绘制这些对象的引用及其关系的图片吗？

probably my answer is following image:

我的回答可能是以下图片：

2 个解决方案

#1

The parameters are stored in command.Parameters. The command uses that collection to enumerate all parameters and send them over the wire.

参数存储在command.Parameters中。该命令使用该集合枚举所有参数并通过线路发送它们。

#2

-2

There are a few ways. See this link:

有几种方法。看到这个链接：

https://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqlcommand.parameters(v=vs.110).aspx

The following example demonstrates how to create a SqlCommand and add parameters:

以下示例演示如何创建SqlCommand并添加参数：

private static void UpdateDemographics(Int32 customerID,
    string demoXml, string connectionString)
{
    // Update the demographics for a store, which is stored 
    // in an xml column. 
    string commandText = "UPDATE Sales.Store SET Demographics = @demographics "
        + "WHERE CustomerID = @ID;";

    using (SqlConnection connection = new SqlConnection(connectionString))
    {
        SqlCommand command = new SqlCommand(commandText, connection);
        command.Parameters.Add("@ID", SqlDbType.Int);
        command.Parameters["@ID"].Value = customerID;

        // Use AddWithValue to assign Demographics.
        // SQL Server will implicitly convert strings into XML.
        command.Parameters.AddWithValue("@demographics", demoXml);

        try
        {
            connection.Open();
            Int32 rowsAffected = command.ExecuteNonQuery();
            Console.WriteLine("RowsAffected: {0}", rowsAffected);
        }
        catch (Exception ex)
        {
            Console.WriteLine(ex.Message);
        }
    }
}

#1