public async Task <List <Training> > GetTrainingByUser(string createdBy) { await connectionProvider.EstablishConnection(); var trainings = connectionProvider.Query <Training>("SELECT id,name,description,datetime,createdBy FROM training where createdBy=@createdBy", new { @createdBy = createdBy }); connectionProvider.Close(); return(trainings.ToList()); }