public IActionResult RegPoz([FromQuery] int?regid) { if (regid == null) { return(NotFound()); } var regpoz = new RegPozViewModel() { FormId = regid.Value }; var data = _dapperService.SelectList <EditableFeatureView, object>("[dbo].[EditableFeature_GetFeaturesByFormId]", new { formId = regid }); if (data != null && data.Count() > 0) { //Selectin whole view from DB to able to extract classifier values as seperate lists for each feature regpoz.FeatureList = data.GroupBy(x => new { x.FormId, x.FeatureId, x.FeatureName, x.FeatureClassifierId }) .Select(x => new FeatureViewModel { FeatureId = x.Key.FeatureId, FeatureName = x.Key.FeatureName, FeatureValue = x.Key.FeatureClassifierId, FeatureClassifier = x.Select(y => new Classifier // should be mai classifier, but don't work with Syncfusion Grid { ClassifierTypeId = y.ClassifierTypeId, Id = y.ClassifierId, Value = y.ClassifierValue }) }) .ToList(); regpoz.DropDowns = _dapperService.SelectList <Classifier, object>("[dbo].[Classifier_GetAll]", null).Select(x => new DropDown { Text = x.Value, FeatureValue = x.Id }).ToList(); } return(View(regpoz)); }