Databases
StackOverflow2013
Postsdbo
POLINQ to Entities does not recognize the method 'Double Parse(System.String)' method, and this method cannot be translated into a store expression
Body
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POLINQ to Entities does not recognize the method 'Double Parse(System.String)' method, and this method cannot be translated into a store expression
    text
    copied!<p>I get the error when i try to run report. The problem is here: <code>model.Referring = Math.Round(_newSurveyResult.Select(m =&gt; string.IsNullOrEmpty(m.Question1) ? 0 : Double.Parse(m.Question1)).Average());</code></p> <pre><code>public class SummaryDetails { public int ChannelId { get; set; } public int ChannelGroupId { get; set; } public string Question1 { get; set; } public string Question2 { get; set; } public string Question3 { get; set; } public string Question4 { get; set; } public int OrganizationId { get; set; } } public ActionResult AreaManager(AreaManagerModel model) { model.ShowCustomerReport = false; model.ShowSurveyReport = true; LoadModelVariablesonPostBack(model, 8); var _newSurveyResult = ( from ls in SessionHandler.CurrentContext.LennoxSurveyResponses join ml in SessionHandler.CurrentContext.MailingListEntries on ls.SurveyCode equals ml.SurveyCode join m in SessionHandler.CurrentContext.MailingLists on ml.MailingListId equals m.MailingListId join ch in SessionHandler.CurrentContext.Channels on m.ChannelId equals ch.ChannelId join cg in SessionHandler.CurrentContext.ChannelGroups on ch.ChannelGroupId equals cg.ChannelGroupId join dcg in SessionHandler.CurrentContext.ChannelGroups on cg.ParentChannelGroupId equals dcg.ChannelGroupId join ncg in SessionHandler.CurrentContext.ChannelGroups on dcg.ParentChannelGroupId equals ncg.ChannelGroupId join pcg in SessionHandler.CurrentContext.ChannelGroups on ncg.ParentChannelGroupId equals pcg.ChannelGroupId select new SummaryDetails { OrganizationId = ch.OrganizationId, Question1 = ls.Question1Answer, Question2 = ls.Question2Answer, Question3 = ls.Question3Answer, Question4 = ls.Question4Answer, ChannelId = ch.ChannelId, ChannelGroupId = model.TMId != 0 ? cg.ChannelGroupId : model.DistrictId != 0 ? dcg.ChannelGroupId : model.AreaId != 0 ? ncg.ChannelGroupId : model.NationId != 0 ? pcg.ChannelGroupId : model.AreaId == 0 ? ncg.ChannelGroupId : model.DistrictId == 0 ? dcg.ChannelGroupId : cg.ChannelGroupId } ); var _newSentSurveys = ( from ml in SessionHandler.CurrentContext.MailingListEntries join m in SessionHandler.CurrentContext.MailingLists on ml.MailingListId equals m.MailingListId join ch in SessionHandler.CurrentContext.Channels on m.ChannelId equals ch.ChannelId join cg in SessionHandler.CurrentContext.ChannelGroups on ch.ChannelGroupId equals cg.ChannelGroupId join dcg in SessionHandler.CurrentContext.ChannelGroups on cg.ParentChannelGroupId equals dcg.ChannelGroupId join ncg in SessionHandler.CurrentContext.ChannelGroups on dcg.ParentChannelGroupId equals ncg.ChannelGroupId join pcg in SessionHandler.CurrentContext.ChannelGroups on ncg.ParentChannelGroupId equals pcg.ChannelGroupId where (ml.EmailDate != null || ml.LetterDate != null || ml.EmailBounce == null) select new SummaryDetails { OrganizationId = ch.OrganizationId, ChannelId = ch.ChannelId, ChannelGroupId = model.TMId != 0 ? cg.ChannelGroupId : model.DistrictId != 0 ? dcg.ChannelGroupId : model.AreaId != 0 ? ncg.ChannelGroupId : model.NationId != 0 ? pcg.ChannelGroupId : model.AreaId == 0 ? ncg.ChannelGroupId : model.DistrictId == 0 ? dcg.ChannelGroupId : cg.ChannelGroupId } ); if (model.ChannelId != 0) { _newSurveyResult = _newSurveyResult.Where(p =&gt; p.ChannelId == model.ChannelId); _newSentSurveys = _newSentSurveys.Where(p =&gt; p.ChannelId == model.ChannelId); } else if (model.TMId != 0) { _newSurveyResult = _newSurveyResult.Where(p =&gt; p.ChannelGroupId == model.TMId); _newSentSurveys = _newSentSurveys.Where(p =&gt; p.ChannelGroupId == model.TMId); } else if (model.DistrictId != 0) { _newSurveyResult = _newSurveyResult.Where(p =&gt; p.ChannelGroupId == model.DistrictId); _newSentSurveys = _newSentSurveys.Where(p =&gt; p.ChannelGroupId == model.DistrictId); } else if (model.AreaId != 0) { _newSurveyResult = _newSurveyResult.Where(p =&gt; p.ChannelGroupId == model.AreaId); _newSentSurveys = _newSentSurveys.Where(p =&gt; p.ChannelGroupId == model.AreaId); } else if (model.NationId != 0) { _newSurveyResult = _newSurveyResult.Where(p =&gt; p.ChannelGroupId == model.NationId); _newSentSurveys = _newSentSurveys.Where(p =&gt; p.ChannelGroupId == model.NationId); } else if (model.NationId == 0) { _newSurveyResult = _newSurveyResult.Where(p =&gt; p.OrganizationId == 8); _newSentSurveys = _newSentSurveys.Where(p =&gt; p.OrganizationId == 8); } else if (model.AreaId == 0) { _newSurveyResult = _newSurveyResult.Where(p =&gt; p.ChannelGroupId == model.LoggedChannelGroupId); _newSentSurveys = _newSentSurveys.Where(p =&gt; p.ChannelGroupId == model.LoggedChannelGroupId); } else if (model.DistrictId == 0) { _newSurveyResult = _newSurveyResult.Where(p =&gt; p.ChannelGroupId == model.LoggedChannelGroupId); _newSentSurveys = _newSentSurveys.Where(p =&gt; p.ChannelGroupId == model.LoggedChannelGroupId); } else if (model.TMId == 0) { _newSurveyResult = _newSurveyResult.Where(p =&gt; p.ChannelGroupId == model.LoggedChannelGroupId); _newSentSurveys = _newSentSurveys.Where(p =&gt; p.ChannelGroupId == model.LoggedChannelGroupId); } model.SentSurveys = _newSentSurveys.Count() &gt; 0 ? _newSentSurveys.Count() : 0; model.CompletedSurveys = _newSurveyResult.Count() &gt; 0 ? _newSurveyResult.Count() : 0; model.PercentageComplete = model.SentSurveys != 0 ? (Convert.ToDouble(model.CompletedSurveys) / Convert.ToDouble(model.SentSurveys)) : 0; if (_newSurveyResult.Count() &gt; 0) { model.Referring = Math.Round(_newSurveyResult.Select(m =&gt; string.IsNullOrEmpty(m.Question1) ? 0 : Double.Parse(m.Question1)).Average()); model.ServicePerformance = Math.Round(_newSurveyResult.Select(m =&gt; string.IsNullOrEmpty(m.Question2) ? 0 : Double.Parse(m.Question2)).Average()); model.InstallPerformance = Math.Round(_newSurveyResult.Select(m =&gt; string.IsNullOrEmpty(m.Question3) ? 0 : Double.Parse(m.Question3)).Average()); model.ReferringLennox = Math.Round(_newSurveyResult.Select(m =&gt; string.IsNullOrEmpty(m.Question4) ? 0 : Double.Parse(m.Question4)).Average()); double overAllScore = CalculateOverallScore( _newSurveyResult.Select(m =&gt; string.IsNullOrEmpty(m.Question1) ? 0 : Double.Parse(m.Question1)).Sum(), _newSurveyResult.Select(m =&gt; string.IsNullOrEmpty(m.Question2) ? 0 : Double.Parse(m.Question2)).Sum(), _newSurveyResult.Select(m =&gt; string.IsNullOrEmpty(m.Question3) ? 0 : Double.Parse(m.Question3)).Sum(), _newSurveyResult.Select(m =&gt; string.IsNullOrEmpty(m.Question4) ? 0 : Double.Parse(m.Question4)).Sum(), _newSurveyResult.Count()); model.OverallScore = Math.Round(overAllScore); } } </code></pre>
 

Querying!

 
Guidance
An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload