[LINQ]使用 LINQ CASE Statement(Use LINQ CASE Statement)

問題

---

使用 LINQ CASE Statement



解決方法

---

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,
    STATUS =(
      itemF.STATUS == "1" ? "上架待審" :
      itemF.STATUS == "2" ? "審畢" :
      itemF.STATUS == "3" ? "下架" : "Unknown"
                        )
            }