可以使用SqlCommandBuilder检索插入的IDENTITY列值(不使用存储过程)？

using System;
using System.Data.SqlClient;

namespace SqlCommandBuilderExample
{
    class Program
    {
        static void Main(string[] args)
        {
            string connectionString = "Data Source=myServerAddress;Initial Catalog=myDataBase;Integrated Security=True";

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

                // 创建一个新的 SqlCommand 对象
                using (SqlCommand command = new SqlCommand("INSERT INTO MyTable (Column1, Column2) VALUES (@Column1, @Column2); SELECT CAST(SCOPE_IDENTITY() AS INT) AS IDENTITY_COLUMN", connection))
                {
                    // 添加参数
                    command.Parameters.AddWithValue("@Column1", "Value1");
                    command.Parameters.AddWithValue("@Column2", "Value2");

                    // 使用 SqlCommandBuilder 自动生成 SqlCommand 对象
                    SqlCommandBuilder.DeriveParameters(command);

                    // 执行命令并检索 IDENTITY 列值
                    int identityValue = (int)command.ExecuteScalar();

                    Console.WriteLine("The IDENTITY value is: " + identityValue);
                }
            }
        }
    }
}