Why 'Lambda' is not supported in my LINQ to Entities syntax

Question

I get an error when I try to run the following query in LINQ to Entities:

public IEnumerable TestOne2()
{
    var query = this.Context.CmnAddressCities
        .Join(this.Context.CmnAddressStates, 
              p => p.StateID, q => q.StateID, 
              (p, q) => SelectSearchColumns)
        .ToList();

     return query;
}

public Expression<Func<CmnAddressCity,CmnAddressState, dynamic>>
    SelectSearchColumns = (e,r) => new
        {
            CityID = e.CityID,
            CityName = e.CityName,
            StateName=r.StateName,
        };

Error Message:

The LINQ expression node type 'Lambda' is not supported in LINQ to Entities.

I would like to know why this error arise and how to solve this.

score 3 · Accepted Answer · answered Feb 13 '13 at 11:16

The following should work:

var query = this.Context.CmnAddressCities
                .Join(this.Context.CmnAddressStates, 
                      p => p.StateID, 
                      q => q.StateID, 
                      SelectSearchColumns)
                .ToList();

See the second to last line for the difference. Your version creates an expression that returns an expression. The EF provider can't translate that to SQL, what is the equivalence of an expression in SQL? That doesn't exist.
You simply have to pass your expression as the parameter itself.

score 2 · Answer 2 · answered Feb 13 '13 at 11:16

2

This expression

(p, q) => SelectSearchColumns

is an expression that returns an expression. Try changing it to SelectSearchColumns on its own.

answered Feb 13 '13 at 11:16

Tim Rogers

21,297
6
52
68

score 2 · Answer 3 · answered Feb 13 '13 at 11:17

In the expression (p, q) => SelectSearchColumns you are passing SelectSearchColumns to the Join method instead of calling it. The query provider then fails to translate it into an SQL statement, because it is passed as a data, rather than being interpreted as a call.

You need either

.Join(this.Context.CmnAddressStates, 
     p => p.StateID, 
     q => q.StateID, 
     (p, q) => SelectSearchColumns(p, q))

or the short version

.Join(this.Context.CmnAddressStates, 
     p => p.StateID, 
     q => q.StateID, 
     SelectSearchColumns)

Why 'Lambda' is not supported in my LINQ to Entities syntax

3 Answers3

Linked