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);
}
