[LINQ]使用 LINQ.Union collection data(Use LINQ.Union collection data)

問題

---

使用 LINQ.Union collection data



解決方法

---

var records = (
    from itemF in db.ItemFund
    select new
    {
     itemF.ITEM_SEQ_NO,
     ITEM_TYPE = "fund",
     ITEM_TYPE_DESC = "基金",
     itemF.ITEM_NM,
     ITEM_CURRENCY = itemF.CUR_C
    }
    ).Union(
      from itemS in db.ItemStock
      select new
      {
       itemS.ITEM_SEQ_NO,
       ITEM_TYPE = "stock",
       ITEM_TYPE_DESC = "股票",
       itemS.ITEM_NM,
       ITEM_CURRENCY = itemS.CUR_C
      }
    );