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

Question

I'm trying to implement a 'IN' clause in my EF query through a lambda expression as follows:

        /*lambda expression to evaluate: status in[a, b, c...n]*/
        _IN myIN = (allStatus, status) =>
        {
            bool lambdaResult = false;
            foreach (int s in statuses)
            {
                if (status == s)
                {
                    lambdaResult = true;
                    break;
                }
            }
            return lambdaResult;
        };

        result = (from v in _entity.CAVouchers
                  join vs in _entity.CAVoucherStatus.Where(vs => (myIN(statuses, vs.VoucherStatusId) == true)) on v.VoucherStatusId equals vs.VoucherStatusId
                  join vsr in _entity.CAVoucherStatusReason on v.VoucherStatusReasonId equals vsr.VoucherStatusReasonid
                  where v.CyberAgent.CAID == caid                       
                  select new ACPVoucher() 
                  {
                      ...
                  }).ToList();

This is throwing a "The LINQ expression node type 'Invoke' is not supported in LINQ to Entities" error due to the "where" condition. Basically what I need is a "where statusId in [1, 2, 3]" kind of clause.

What is failing?...any tips on how to do this? The same approach is working for me when applied to a generic list.

Thanks

BrokenGlass · Accepted Answer · 2011-04-07 20:11:25Z

3

You could just do a contains query:

where statuses.Contains(vs.VoucherStatusId)

answered Apr 7, 2011 at 20:11

BrokenGlass

161k28 gold badges297 silver badges339 bronze badges

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

Comments

Bala R · Accepted Answer · 2011-04-07 20:12:46Z

1

Can you try this?

join vs in _entity.CAVoucherStatus.Where(vs => statuses.Contains(vs.VoucherStatusId)) on v.VoucherStatusId equals vs.VoucherStatusId

answered Apr 7, 2011 at 20:12

Bala R

109k23 gold badges203 silver badges212 bronze badges

Comments

Community · Accepted Answer · 2017-05-23 11:55:26Z

0

Different LINQ providers support different tricks; as it happens LINQ-to-SQL works with invoke. EF: not so much. If you are building the expression by hand, you may need to either form the expression without invoke, or to use a re-writer to flatten it. There's a rewriter example here that illustrates how to do this: Combining two lambda expressions in c#

edited May 23, 2017 at 11:55

CommunityBot

11 silver badge

answered Apr 7, 2011 at 20:12

Marc Gravell

1.1m273 gold badges2.6k silver badges3k bronze badges

Collectives™ on Stack Overflow

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

3 Answers 3

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related