public List <EstudiosDomain> ListarComJogos()
{
List <EstudiosDomain> estudios = new List <EstudiosDomain>();
SqlConnection connection = new SqlConnection(banco);
var query = "SELECT E.IdEstudio, E.NomeEstudio FROM Estudios E";
SqlCommand command = new SqlCommand(query, connection);
connection.Open();
SqlDataReader leitor;
leitor = command.ExecuteReader();
while (leitor.Read())
{
EstudiosDomain estudios1 = new EstudiosDomain
{
IdEstudio = Convert.ToInt32(leitor["IdEstudio"]),
NomeEstudio = leitor["NomeEstudio"].ToString(),
Jogos = jogos.ListarPorEstudio(Convert.ToInt32(leitor["IdEstudio"]))
};
estudios.Add(estudios1);
}
connection.Close();
return(estudios);
}
