Sub Query In Linq
-
Hi. I have write linq query using contains but it gives an errror My query is var subId = from a in MyConnection.AccMst.MENU_TREE_STRUCTUREs where a.MTS_SUBID == null select new { a.MTS_ID }; var query = from m in MyConnection.AccMst.MENU_TREE_STRUCTUREs join u in MyConnection.AccMst.USER_RIGHT_DETAILs on m.MTS_ID equals u.URD_MTS_GUID join r in MyConnection.AccMst.USER_RIGHT_MASTERs on u.URD_URM_ID equals r.URM_ID where r.URM_RM_ID == Convert.ToDecimal(ddlRoleDesc.SelectedValue) && subId.Contains(m.MTS_ID) && r.URM_CM_COMP_CODE == Convert.ToDecimal(SessionClass.CompanyCode) select new { m.MTS_ID, u.URD_ACCESS }; Error:The type arguments for method 'System.Linq.Queryable.Contains(System.Linq.IQueryable, TSource)' cannot be inferred from the usage. Try specifying the type arguments explicitly.