[Tips] Entity Framework and JSON

需求

提供JSON的格式資料,但是不要將所有的entity欄位都輸出.

 

方式

 

輸出所有欄位

   1: using (MyStockEntities entities = new MyStockEntities())

   2: {

   3:     JavaScriptSerializer js = new JavaScriptSerializer();

   4:     return js.Serialize(entities.CodeStocks);

   5: }

 

輸出需要的欄位

   1: using (MyStockEntities entities = new MyStockEntities())

   2: {

   3:     JavaScriptSerializer js = new 

   4:     JavaScriptSerializer();

   5:     var results = from cols in entities.CodeStocks

   6:         select new

   7:         {

   8:             StockId = cols.StockId,

   9:             StockName = cols.StockName,

  10:             StockType = cols.StockType

  11:         };

  12:     return js.Serialize(results);

  13: }