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