使用ASP.NET格式化TSQL字符串以模拟SQL Manager的最佳方式是什么？

string connectionString = "YourConnectionString";
string tsqlQuery = "SELECT * FROM YourTable WHERE Column1 = @Param1 AND Column2 = @Param2";

using (SqlConnection connection = new SqlConnection(connectionString))
{
    SqlCommand command = new SqlCommand(tsqlQuery, connection);
    command.Parameters.AddWithValue("@Param1", value1);
    command.Parameters.AddWithValue("@Param2", value2);

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

    // 处理查询结果
    while (reader.Read())
    {
        // 读取数据
    }

    reader.Close();
}

StringBuilder tsqlQuery = new StringBuilder();
tsqlQuery.Append("SELECT * FROM YourTable WHERE 1=1");

if (!string.IsNullOrEmpty(condition1))
{
    tsqlQuery.Append(" AND Column1 = @Param1");
    command.Parameters.AddWithValue("@Param1", condition1);
}

if (!string.IsNullOrEmpty(condition2))
{
    tsqlQuery.Append(" AND Column2 = @Param2");
    command.Parameters.AddWithValue("@Param2", condition2);
}

// 执行查询...