如何使用“In”在实体框架中使用子查询 [英] How to use "In" with subquery in entity framework

问题描述

我使用实体框架在以下查询的帮助下从数据库获取结果：

Hi,

I am using entity framework for getting the result from database with the help of the following query:

var resManagerGroup = (from objManagerGroup in objEntities.LK_MANAGER_GROUP
                                  where objManagerGroup.user_id == iManagerId && objManagerGroup.group_id != null
                                  select new
                                  {
                                      groupId = objManagerGroup.group_id
                                  });

           var resAssessmentForMarking = (from objAssessmentsForEvaluation in objEntities.UL_ASSESSMENT_EVALUATION_BY_MANAGER
                                          where (objAssessmentsForEvaluation.assessing_status == 0 || objAssessmentsForEvaluation.assessing_status == 1)
                                          && objAssessmentsForEvaluation.courseLinkId != null
                                          select new
                                          {
                                              assessmentId = objAssessmentsForEvaluation.assessment_Id,
                                              groupId = objAssessmentsForEvaluation.group_Id
                                          });

    resAssessmentForMarking = resAssessmentForMarking.Where(s => resManagerGroup.Contains(s.groupId));

< br $>




但我收到以下错误：



错误20' System.Linq.IQueryable< int>'不包含'Contains'的定义和最佳扩展方法重载'System.Linq.ParallelEnumerable.Contains< tsource>（System.Linq.ParallelQuery< tsource>，TSource）'有一些无效的论点



请建议一些解决方案。



谢谢，



问候，

Ashish

but I am getting the following error:

Error 20 'System.Linq.IQueryable<int>' does not contain a definition for 'Contains' and the best extension method overload 'System.Linq.ParallelEnumerable.Contains<tsource>(System.Linq.ParallelQuery<tsource>, TSource)' has some invalid arguments

Please suggest some solution.

Thanks,

Regards,
Ashish

推荐答案

检查出来

http://stackoverflow.com/questions/2066084/in-operator-in-linq？ answertab = active＃tab-top [ ^ ]

这篇关于如何使用“In”在实体框架中使用子查询的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！