public async Task <List <ProjectViewModel> > Handle(GetAllProjectsQuery request, CancellationToken cancellationToken) { //Entity Framework com padrão CQRS //---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- //var projects = _dbContext.Projects; //var projectsViewModel = await projects.Select(p => new ProjectViewModel(p.Id, p.Title, p.CreatedAt)).ToListAsync(); //return projectsViewModel; //Dapper //using (var sqlConnection = new SqlConnection(_connectionString)) //{ // var sql = "SELECT Id, Description FROM Skills"; // var result = await sqlConnection.QueryAsync<ProjectViewModel>(sql); // return result.ToList(); //} //---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- //Padrão Repository //---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- var projects = await _projectRepository.GetAllAsync(); var projectsViewModel = projects.Select(p => new ProjectViewModel(p.Id, p.Title, p.CreatedAt)).ToList(); return(projectsViewModel); //---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- }
public async Task <List <ProjectViewModel> > Handle(GetAllProjectsQuery request, CancellationToken cancellationToken) { var projects = await _repository.GetAllAsync(); var projectsViewModel = projects.Select(p => new ProjectViewModel(p.Id, p.Title, p.CreatedAt)).ToList(); return(projectsViewModel); }