how to use a method with 2 parameters in my lambda expression

Question

I use linq to access a table from my DB using Entity Framework

MyDBEntities context = new MyDBEntities;
int id = 111;
var item = context.MyTable.Where(i => i.id == id).Single();

This works fine but now I create a method I wish to use instead of the id check:

bool AreNear(string Adress, object Adress)

I'd like to use that way

 string adress = "...";
 var item = context.MyTable.Where(i => AreNear(i.adress,adress) ).Single();

but I get an error at the execution saying I can't use the method in my query is there a way to make it work?

You are using EF, the queries (Where) have to be converted to SQL... — Henk Holterman
– Henk Holterman, Commented May 26, 2011 at 14:23

Daniel Hilgarth · Accepted Answer · 2011-05-26 14:21:01Z

1

Unfortunately, there is no way to make it work.
The reason for this is that the LINQ query isn't really executed as .NET code but it is translated into SQL by the EF provider. This EF provider doesn't know how to translate AreNear into SQL, so it fails.

answered May 26, 2011 at 14:21

Daniel Hilgarth

175k41 gold badges346 silver badges450 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Henk Holterman Over a year ago

Then tell "why" or make it a comment.

Collectives™ on Stack Overflow

how to use a method with 2 parameters in my lambda expression

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related