如何将.NET DateTimeOffset转换为Sql DateTimeOffset

DateTimeOffset dateTimeOffset = DateTimeOffset.Now;

using System.Data.SqlClient;

SqlConnection connection = new SqlConnection("connectionString");
SqlCommand command = new SqlCommand("INSERT INTO tableName (columnName) VALUES (@dateTimeOffset)", connection);

SqlParameter parameter = new SqlParameter("@dateTimeOffset", SqlDbType.DateTimeOffset);
parameter.Value = dateTimeOffset;

command.Parameters.Add(parameter);

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