瀵艰 澶у濂?灏忛噾鏉ヤ负澶у瑙ｇ瓟浠ヤ笂鐨勯棶棰樸€俥find鐢甸挗鐞翠环鏍硷紝efinin杩欎釜寰堝浜鸿繕涓嶇煡閬?鐜板湪璁╂垜浠竴璧锋潵鐪嬬湅鍚э紒1銆乿ar b1s = from b in
澶у濂?灏忛噾鏉ヤ负澶у瑙ｇ瓟浠ヤ笂鐨勯棶棰樸€俥find鐢甸挗鐞翠环鏍硷紝efinin杩欎釜寰堝浜鸿繕涓嶇煡閬?鐜板湪璁╂垜浠竴璧锋潵鐪嬬湅鍚э紒
1銆乿ar b1s = from b in tablebwhere ...select b.b1;var c2s = from c in tablecwhere ...select c.c2;var a1sanda2s = from a in tableawhere !b1s.contains(a.a3)&& c2s.contains(a.a4)select new {a.a1,a.a2};娌℃湁杩欎釜璇硶锛屼絾鍙互鍙橀€氾紝绀轰緥浠ｇ爜锛歩nt[] arr=new int[]{1,2,35,34,54,100};//绀烘剰銆?/p>
2銆佸疄闄呬綘鑲畾鎷垮埌浜嗚繖浜涙暟鎹簡锛屽叾瀹冩暟鎹被鍨嬬被浼?/dbcontext涓篍f涓婁笅鏂囷紝b涓轰綘鐨勮〃鍚峱id涓轰綘鐨勫瓧娈祐ar data=dbcontext.b.where(c=>arr.contains(c.pid));//data鍗充负鎵€姹傘€?/p>
鏈枃鍒版鍒嗕韩瀹屾瘯锛屽笇鏈涘澶у鏈夋墍甯姪銆?/p>
鍏嶈矗澹版槑锛?/span>鏈枃鐢辩敤鎴蜂笂浼狅紝濡傛湁渚垫潈璇疯仈绯诲垹闄わ紒