c# LINQ to Entities does not recognize the method 'Boolean

Question

How to address Boolean method below. The value Online has to be set. The error I get is c# LINQ to Entities does not recognize the method 'Boolean foreach (var i in (from a in db.Color join i in db.ColorClothes on a.InstallationId equals i.InstallationId where a.Id == Id select new { ID= i.id OnLine = Utilities.IsConnectionValid(i.InstallationId) ? true : false I get the error right here }).ToList())

Rajkiran Swain · Answer

https://stackoverflow.com/questions/34381579/linq-to-entities-does-not-recognize-the-method-boolean-toboolean

Muralidharan Deenathayalan · Answer

You can't call directly arbitrary methods in Linq to entities. For example if you foreach (var i in (from a in db.Color join i in db.ColorClothes on a.InstallationId equals i.InstallationId where a.Id == Id select new { ID= i.id OnLine = true or false }).ToList()) this will work. So you need to change comparison logic.