无法创建“匿名类型”类型的常量值。在此上下文中仅支持基元类型或枚举类型。在Linq C#

Question

我想连接2-3个数据来自数据库的列表和2个对象类型为数据的列表，如何从中获得实际的结果？下面是我的代码和对象列表

var calls = context.queued_calls;

//to get classifications into list
var classificationsToList = (from c in context.classifications
                             select new { c.classification_id, c.classification1 }).ToList();

//to get tha users from the user table 
var users = (from u in context.users
             select new { u.user_id, u.first_name, u.last_name }).ToList();

//to get agents from agents table
var agents = (from a in context.agents
              select new { a.agent_id, a.user_id }).ToList();

这是四个list对象，这是我对它执行的查询

var agentsClass = (from cs in calls
                  join ag in agents on cs.agent_id equals ag.agent_id
                  join u in users on ag.user_id equals u.user_id
                  join cls in classificationsToList on cs.classification_id equals cls.classification_id
                  group cs by new { cs.classification_id, cls.classification1, cs.agent_id, u.user_id } into clas                         
                  select new { agent_id = clas.Key.agent_id, user_id = clas.Key.user_id, classification = clas.Key.classification1, classifications_count = clas.Count() }).OrderBy(a => a.agent_id).ToList();

Answer 1

我得到了解决方案，我需要做的就是将调用转换为列表并解决错误