从SqlConnection.Execute存储过程取回插入的ID

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

public class Program
{
    public static void Main()
    {
        string connectionString = "YourConnectionString";
        string storedProcedureName = "YourStoredProcedureName";

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

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

                // 创建一个SqlParameter对象，用于接收插入的ID值
                SqlParameter outputParameter = new SqlParameter("@InsertedID", SqlDbType.Int);
                outputParameter.Direction = ParameterDirection.Output;
                command.Parameters.Add(outputParameter);

                // 执行存储过程
                command.ExecuteNonQuery();

                // 获取插入的ID值
                int insertedID = Convert.ToInt32(outputParameter.Value);
                Console.WriteLine("插入的ID值为：" + insertedID);
            }
        }
    }
}