使用C#获取插入行的id

using System;
using System.Data.SqlClient;

namespace GetInsertedID
{
    class Program
    {
        static void Main(string[] args)
        {
            string connectionString = "Server=localhost;Database=YourDatabase;User Id=YourUsername;Password=YourPassword;";
            string insertQuery = "INSERT INTO YourTable (Column1, Column2) VALUES (@Value1, @Value2); SELECT CAST(SCOPE_IDENTITY() AS INT);";

            using (SqlConnection connection = new SqlConnection(connectionString))
            {
                SqlCommand command = new SqlCommand(insertQuery, connection);
                command.Parameters.AddWithValue("@Value1", "Value1");
                command.Parameters.AddWithValue("@Value2", "Value2");

                connection.Open();
                int insertedID = (int)command.ExecuteScalar();
                connection.Close();

                Console.WriteLine($"Inserted ID: {insertedID}");
            }
        }
    }
}