Our Training Programs

All contents are copyright of their authors.

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

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

David Smith

8yAsked Nov 3, 2017, 7:01 PM6.8kLINQ

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())

Know the answer? Post it — somebody with the same question will find it here.

It is the same account you read, post and publish with — and you will come straight back to this page.

Rajkiran Swain8y ago
https://stackoverflow.com/questions/34381579/linq-to-entities-does-not-recognize-the-method-boolean-toboolean
8y ago
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.