public static informacoesTO GetinformacoesByID(long id) { string conexao = Convert.ToString(ConfigurationSettings.AppSettings["STRING_CONNECTION"]); MySqlConnection db = new MySqlConnection(conexao); informacoesTO objeto = new informacoesTO(); try { string sql = "SELECT * FROM informacoes WHERE id=@id;"; MySqlCommand comand = new MySqlCommand(sql); comand.Parameters.AddWithValue("@id", id); db.Open(); comand.Connection = db; comand.ExecuteNonQuery(); using (MySqlDataReader dr = comand.ExecuteReader()) { if (dr.Read()) { objeto = Load(dr); } } } finally { db.Close(); } return(objeto); }