C# - SQLClient - 最简单的INSERT

using System;
using System.Data.SqlClient;

namespace SimpleInsert
{
    class Program
    {
        static void Main(string[] args)
        {
            string connectionString = "Server=localhost;Database=myDatabase;User Id=myUsername;Password=myPassword;";
            string insertCommand = "INSERT INTO myTable (column1, column2) VALUES (@value1, @value2);";

            using (SqlConnection connection = new SqlConnection(connectionString))
            {
                SqlCommand command = new SqlCommand(insertCommand, connection);
                command.Parameters.AddWithValue("@value1", "exampleValue1");
                command.Parameters.AddWithValue("@value2", "exampleValue2");

                try
                {
                    connection.Open();
                    int rowsAffected = command.ExecuteNonQuery();
                    Console.WriteLine($"{rowsAffected} rows affected.");
                }
                catch (Exception ex)
                {
                    Console.WriteLine($"Error: {ex.Message}");
                }
            }
        }
    }
}