LINQ calling a method inside Select passing as parameter the selected item in linq

Question

I want to call method in linq query select part of property. is it possible to call a method in inside select query.

enter image description here

Answer 1

1: please write your code

2: it can not be done because you're function is in c# and the query wants to run in sql.

you have 3 options:

a: try quantify CancleInvoice after your query in c#

b: use simple codes that ef can translate to sql code

b: build your function in sql server and then you can use it in ef