C# Entity Framework .Any() Unable to create a constant value of type 'Anonymous type'

Question

I am getting a list of my database, selecting certain things, then i want to query another database where the original list contains this databases job reference

 var jobRefs = context.jobs.Where(j => j.LSM_Status == null &&
                                       j.despatched_time == null
                                       )
      .Select(x => new { x.job_ref, x.volumes_env, x.postout_deadline , x.UniqNo })
      .ToList();


var UpdatedRefs = context.customerslas.Where(c => jobRefs.Any(z=>z.job_ref == c.job_ref) &&
                                      (c.invoiced == 1 ||
                                       c.invoiced == 2) &&
                                       c.active == 1)
                                       .Select(c => c.job_ref)
                                       .ToList();

And get this error

Unable to create a constant value of type 'Anonymous type'. Only primitive types or enumeration types are supported in this context.'

Seeing the answer you accepted your statement *query another database* can't be true. — Gert Arnold, Oct 02 '18 at 14:43

score 1 · Accepted Answer · answered Oct 02 '18 at 10:19

The ToList() in the first first query is fetching data to a collection in memory while the second query, where you compare the data, is in database. To solve this you need to make them in the same area, either db or memory.

Easiest way, and recommended, would be to just remove ToList() from the first query

var jobRefs = context.jobs.Where(j => j.LSM_Status == null &&
                                       j.despatched_time == null
                                       )
      .Select(x => new { x.job_ref, x.volumes_env, x.postout_deadline , x.UniqNo });


var UpdatedRefs = context.customerslas.Where(c => jobRefs.Any(z=>z.job_ref == c.job_ref) &&
                                      (c.invoiced == 1 ||
                                       c.invoiced == 2) &&
                                       c.active == 1)
                                       .Select(c => c.job_ref)
                                       .ToList();

C# Entity Framework .Any() Unable to create a constant value of type 'Anonymous type'

1 Answers1