public Country GetCountryById(int id) { _queryBuilder.AddSelect("*"); _queryBuilder.SetFrom("reg_landen"); _queryBuilder.AddWhere("land_id = @id"); string query = _queryBuilder.BuildQuery(); Dictionary <string, object> parameters = new Dictionary <string, object>(); parameters.Add("@id", id); var country = _optionRepository.GetCountryById(query, parameters); return(_mapper.Map <Country>(country)); }