如何正确地将日期时间从c#传递给sql？

DateTime dateTime = DateTime.Now;

using System.Data.SqlClient;

string connectionString = "Data Source=your_server;Initial Catalog=your_database;Integrated Security=True";
string sql = "INSERT INTO your_table (date_time_column) VALUES (@dateTime)";

using (SqlConnection connection = new SqlConnection(connectionString))
{
    SqlCommand command = new SqlCommand(sql, connection);
    command.Parameters.AddWithValue("@dateTime", dateTime);

    connection.Open();
    command.ExecuteNonQuery();
}

CREATE TABLE your_table (
    id INT PRIMARY KEY,
    date_time_column DATETIME
);