public static List <Musica> GetAll()
{
string query = "select * from musica";
BlueORM.Command cmd = new BlueORM.Command(query);
return(cmd.GetAll <Musica>());
}
public static List <Genero> GetAll()
{
string query = "select * from genero";
BlueORM.Command cmd = new BlueORM.Command(query);
return(cmd.GetAll <Genero>());
}
public static List <Genero> GetAllByMusic(int codMusica)
{
string query = @"select g.* from genero g
inner join musica_genero mg on g.codGenero = mg.codGenero
where mg.codMusica = " + codMusica;
BlueORM.Command cmd = new BlueORM.Command(query);
return(cmd.GetAll <Genero>());
}