Converting c# data from entity framework to a valid json type

Question

i have below method:

    [HttpPost]
    public ActionResult GetData()
    {
        var data= (dynamic)null;
        using (DBContext context = new DBContext())
        {
            data= context.MyObject.Where(i=> i.TypeId == 1).OrderBy(k => k.Name).Select(w => new
            {
                description = w.Description
            }).ToList();       
        }

        return Json(data, JsonRequestBehavior.AllowGet);
    }

so I want to convert the data correctly into a json object, but i am not sure if i am doing correctly. This data returned should be used in a javascript.

I have google a lot and i have found example like below, maybe I should do a similar thing, but i do not know how:

var keyValues = new Dictionary<string, string>
               {
                   { "emailSend", textBox1.Text },
                   { "toEmail", textBox2.Text }
               };

JavaScriptSerializer js = new JavaScriptSerializer();
string json = js.Serialize(keyValues);
MessageBox.Show(json);

Your code will return Json? your calling Json() in your controller. This will convert your object into Json. No need for anything else. — Liam
– Liam, Commented Sep 23, 2013 at 11:17
I should be return json data but i am not sure if i am done it correctly from the controller. — Willy
– Willy, Commented Sep 23, 2013 at 11:19
MessageBox.Show is a windows method and won't work in ASP.Net also — Liam
– Liam, Commented Sep 23, 2013 at 11:19
return Json(data, JsonRequestBehavior.AllowGet); is the correct way — Johan
– Johan, Commented Sep 23, 2013 at 11:19

Darin Dimitrov · Accepted Answer · 2013-09-23 11:25:43Z

7

You should not be using any JavaScriptSerializer. Just return Json as you already did. That's the correct approach of sending JSON to the client from a controller action. The model you passed as parameter will automatically be serialized into a JSON string by the framework. Also you don't need to be setting JsonRequestBehavior.AllowGet because your controller action is decorated with the [HttpPost] attribute meaning that it can only be invoked with the POST verb and never with GET. This is required only for controller actions that are returning JsonResult and which can be invoked with the GET verb.

answered Sep 23, 2013 at 11:25

Darin Dimitrov

1.0m275 gold badges3.3k silver badges3k bronze badges

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

Collectives™ on Stack Overflow

Converting c# data from entity framework to a valid json type

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related