[LINQ]使用 LINQ 做NOT IN篩選資料(Using LINQ do NOT IN filter data)

問題

---

使用 LINQ 做NOT IN篩選資料



解決方法

---

var records = from view in db.V_CUSTOMER

        select new

        {

            CUSTOMER_NO = view.CUSTOMER_NO,

            ID_NO = view.ID_NO,

            CUST_NAME = view.CUST_NAME,

        };

//(取得篩選資料)

var alreadyApply = (from apply in db.CUSTCLOSEACCAUDIT

        where apply.AUDIT_FINISH_DATE == null

        select apply.CUSTOPENDEPT_GD).Distinct();

var ApplyList = alreadyApply.ToList();

//NOT IN寫法

records = records.Where(o => !ApplyList.Contains(o.CUSTOPENDEPT_GD));

// IN寫法

records = records.Where(o => ApplyList.Contains(o.CUSTOPENDEPT_GD));