Exemplo n.º 1
0
        public static List <Experimento> GetAllExperimentosByCondicao(Condicao condicao)
        {
            if (condicao == null)
            {
                return(null);
            }

            using (IDbConnection cnn = new SQLiteConnection(GetConnectionString())) {
                List <ExperimentoParaCondicao> experimentoParaCondicoes = cnn.Query <ExperimentoParaCondicao>("SELECT * FROM ExperimentoParaCondicao WHERE IdCondicao = @Id", condicao).ToList();

                return(experimentoParaCondicoes.Select(it => {
                    return ExperimentoService.GetById(it.IdExperimento);
                }).ToList());
            }
        }