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
– Krishna, Commented Jul 6, 2017 at 12:53
try this answer this guy was facing similar issue stackoverflow.com/a/10566433/2745294 — Sushil Mate
– Sushil Mate, Commented Jul 6, 2017 at 13:02
try this should help you. stackoverflow.com/questions/726334/… — Onic Team
– Onic Team, Commented Jul 6, 2017 at 13:26

Aleks Andreev · Accepted Answer · 2017-07-06 13:23:16Z

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 6, 2017 at 13:23

answered Jul 6, 2017 at 13:04

Aleks Andreev

7,0548 gold badges31 silver badges38 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

dotnetcoder Over a year ago

getting compilation error.list<sm> does not contain definition for sms, id. fields of tables are not coming.

Aleks Andreev Over a year ago

@dotnetcoder sorry, my fault. Please check edited version

Collectives™ on Stack Overflow

how to get table data in json using linq and entityframework

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related