LINQ to Entities does not recognize the method

After my unit tests showed all green, there was still a bug in my code.

System.NotSupportedException: LINQ to Entities does not recognize the method ‘System.Collections.Generic.IList`1[iCal.ISchedulerEvent] ProcessItem(iCal.ISchedulerEvent)’ method, and this method cannot be translated into a store expression.

Solution is to call the ToList() method to get the data into dotNET.

var possibleResults = DbSet
        .Where(item => item.Start < request.End)
        .ToList(); // else the link-to-entities will complain
var result = possibleResults
        .SelectMany(item => ProcessItem(item))
        .OrderBy(item => item.Start)
        .FirstOrDefault();

About erictummers

Working in a DevOps team is the best thing that happened to me. I like challenges and sharing the solutions with others. On my blog I’ll mostly post about my work, but expect an occasional home project, productivity tip and tooling review.
This entry was posted in Development and tagged , , . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.