Linq to entity - calling a custom method from a request

Question

In my project, I use several linq queries to get a list of prices. I need to calculate values ​​based on these prices.

Is it possible to call a user-defined method (which, ideally, can be in an entity class) directly from a linq query, for example, to do this would be ideal.

from foo in Foo
select new {
  price = foo.Price,
  priceclass = foo.GetClassOfPrice()
}

There will be no access to data from GetClassOfPrice, only static code based on price.

Thanks in advance!

Answer 1

Linq-To-Entities , (EDMX). . , , . .

Answer 2

LINQ to Objects, SQL. - - , .

var foos = context.Foo.ToList()
                      .Select( f => new
                       {
                            price = f.Price,
                            priceClass = f.GetClassOfPrice()
                       } );

, ToList (Where), , . , , ToList . LINQ .

Answer 3

, , LINQ SQL. , .

Answer 4

, linq , : http://msdn.microsoft.com/en-us/library/system.data.objects.sqlclient.sqlfunctions.aspx

http://msdn.microsoft.com/en-us/library/system.data.objects.entityfunctions.aspx