how to get table data in json using linq and entityframework

Question

i have table with these fields sms,id,updtd_date. im trying get it in json but date value getting in different format. how to get updt_time field in string in json

o/p

/Date(1497309538000)/

req op

13-06-2017 04:48

code

 public ActionResult getSMS()
        {
            using (DBEntities dc = new DBEntities())
            {
                var data = dc.sms.OrderByDescending(a => a.id).ToList();
                return Json(new { data = data }, JsonRequestBehavior.AllowGet);
            }
        }

whatever date you got is json date format ? what are you looking for ? — Krishna, Jul 06 '17 at 12:53
try this answer this guy was facing similar issue https://stackoverflow.com/a/10566433/2745294 — Sushil Mate, Jul 06 '17 at 13:02
try this should help you. https://stackoverflow.com/questions/726334/asp-net-mvc-jsonresult-date-format/4540007#4540007 — Onic Team, Jul 06 '17 at 13:26

Aleks Andreev · Accepted Answer · 2017-07-06T13:23:16.813

0

You can serialize your date manually:

public ActionResult getSMS()
{
    using (DBEntities dc = new DBEntities())
    {
        var data = dc.sms.OrderByDescending(a => a.id);
        return Json(data.Select(d => new { d.sms, d.id, updtd_date = d.ToString("dd-MM-yyyy HH:mm") }).ToList(), JsonRequestBehavior.AllowGet);

    }
}

edited Jul 06 '17 at 13:23

answered Jul 06 '17 at 13:04

Aleks Andreev

7,016
8
29
37

getting compilation error.list does not contain definition for sms, id. fields of tables are not coming. – dotnetcoder Jul 06 '17 at 13:18
@dotnetcoder sorry, my fault. Please check edited version – Aleks Andreev Jul 06 '17 at 13:27

how to get table data in json using linq and entityframework

1 Answers1