C# | SqlCommand查询中的Use参数

string connectionString = "Data Source=server;Initial Catalog=database;User ID=username;Password=password;";
string query = "SELECT * FROM TableName";

using (SqlConnection connection = new SqlConnection(connectionString))
{
    connection.Open();

    using (SqlCommand command = new SqlCommand(query, connection))
    {
        command.CommandType = CommandType.Text;
        command.Parameters.AddWithValue("@Param", value);

        // 使用Use参数指定要查询的数据库
        command.Parameters.AddWithValue("@Use", "DatabaseName");

        SqlDataReader reader = command.ExecuteReader();

        while (reader.Read())
        {
            // 处理查询结果
        }

        reader.Close();
    }
}