我們正在將 SQL 查詢轉(zhuǎn)換為 linq 查詢，此轉(zhuǎn)換涉及如下兩個(gè)表：select * from Tbl_Vulpith_Registration where Profile_Pic is not null   and MemId IN (select MemId from Tbl_List_Services)Tbl_Vulpith_Registration并且Tbl_List_Services是涉及的兩個(gè)表。memId 是兩個(gè)表中的公共列。這是我們嘗試將上述 SQL 查詢轉(zhuǎn)換為 linq 的內(nèi)容：  var reglist = objentity.Tbl_Vulpith_Registration.Select(a => a).Where(a => a.Profile_Pic != null);    var listmemsmemIds = objentity.Tbl_List_Services.Select(b => b.MemId).ToList();    var finalist = reglist.Select(b => b).Where(c => c.MemId.Contains(listmemsmemIds));