public void DeleteFor(int vacancyId) { var vacancyLocations = _getOpenConnection.Query <Entities.VacancyLocation>("SELECT * FROM dbo.VacancyLocation WHERE VacancyId = @VacancyId ORDER BY VacancyLocationId DESC", new { VacancyId = vacancyId }); foreach (var vacancyLocation in vacancyLocations) { _getOpenConnection.DeleteSingle(vacancyLocation); } }