处理DBNull的最佳方法是什么？

using System;
using System.Data.SqlClient;

SqlConnection connection = new SqlConnection("connectionString");
SqlCommand command = new SqlCommand("INSERT INTO TableName (Column1, Column2) VALUES (@Column1, @Column2)", connection);

string column1Value = "SomeValue";
object column2Value = null;

if (column2Value == null)
{
    command.Parameters.AddWithValue("@Column2", DBNull.Value);
}
else
{
    command.Parameters.AddWithValue("@Column2", column2Value);
}

command.Parameters.AddWithValue("@Column1", column1Value);

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

using System;
using System.Data.SqlClient;

SqlConnection connection = new SqlConnection("connectionString");
SqlCommand command = new SqlCommand("SELECT Column1, Column2 FROM TableName", connection);

connection.Open();
SqlDataReader reader = command.ExecuteReader();

while (reader.Read())
{
    string column1Value = reader.IsDBNull(0) ? "" : reader.GetString(0);
    int column2Value = reader.IsDBNull(1) ? 0 : reader.GetInt32(1);

    Console.WriteLine($"Column1: {column1Value}, Column2: {column2Value}");
}

reader.Close();
connection.Close();