How to return json data from ASP.NET MVC controller?

Question

3.00/5 (1 vote)

See more:

My Model:

C#

 public class Cls{
    public int Id {get;set;}
    public string name {get;set;}
}

My Controller:

C#

public JsonResult jsonClassList()
       {
           var classes = from c in db.Cls
                         select c;
           return Json(new { Classes = classes }, JsonRequestBehavior.AllowGet);
       }

What I have tried:

I want to get list of data in json format?

C#

{
  Classes:
  [
  {
    Id : 1,
    name: one
  },
  {
    Id : 2,
    name: two
  },
  {
    Id : 3,
    name: three
  }
 ]
}

Posted 10-Jul-16 20:02pm

Muhammad Shan

Updated 11-Jul-16 2:58am

v4

Add a Solution

Comments

Suvendu Shekhar Giri 11-Jul-16 2:05am

What is the JSON result you are getting?

Muhammad Shan 11-Jul-16 2:08am

I'm getting this error:

A circular reference was detected while serializing an object of type 'System.Data.Entity.DynamicProxies.Clas_9509CA648588A0D8B4283C10ABF34A411C9EAFC459E3E2D68EDA7B7326F2B1B1'.

Karthik_Mahalingam 11-Jul-16 2:19am

that is not a valid json.

Muhammad Shan 11-Jul-16 2:22am

{ Classes:
[
{
Id : 1,
name: one
},
{
Id : 2,
name: two
},
{
Id : 3,
name: three
}
]
}

Karthik_Mahalingam 11-Jul-16 2:37am

you want this output?

Muhammad Shan 11-Jul-16 2:23am

Getting this error:
A circular reference was detected while serializing an object of type 'System.Data.Entity.DynamicProxies.Clas_9509CA648588A0D8B4283C10ABF34A411C9EAFC459E3E2D68EDA7B7326F2B1B1'.

Beginner Luck 11-Jul-16 2:24am

It is same as normal linq instead of josn. I will post if still not sure

Muhammad Shan 11-Jul-16 2:25am

Plz post, so that i can solve my problem

Muhammad Shan 11-Jul-16 2:53am

Getting this error:
A circular reference was detected while serializing an object of type 'System.Data.Entity.DynamicProxies.Clas_9509CA648588A0D8B4283C10ABF34A411C9EAFC459E3E2D68EDA7B7326F2B1B1'.

Can you solve it.

Karthik_Mahalingam 11-Jul-16 2:41am

return Json( new { Classes= classes} , JsonRequestBehavior.AllowGet);
this works fine.. it gives the desired format

Muhammad Shan 11-Jul-16 2:43am

Getting this error:
A circular reference was detected while serializing an object of type 'System.Data.Entity.DynamicProxies.Clas_9509CA648588A0D8B4283C10ABF34A411C9EAFC459E3E2D68EDA7B7326F2B1B1'.

Can you solve this.

3 solutions

Solution 3

JsonResult Type in MVC[^]

public ActionResult SomeActionMethod() {
return Json(new {foo="bar", baz="Blech"});
}

Posted 11-Jul-16 2:58am

Vignesh Mani

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Karthik_Mahalingam · Accepted Answer · 2016-07-10T21:02:00

Solution 1

try this

C#

public JsonResult jsonClassList()
       {
           var classes =   db.Cls.ToList();
           var obj = new { Classes = classes };
           return Json(obj, JsonRequestBehavior.AllowGet);
       }

Posted 10-Jul-16 21:02pm

Karthik_Mahalingam

F-ES Sitecore · Accepted Answer · 2016-07-10T22:31:00

I can't see how the code you posted would give you that error so I think you're cutting down the code and missing out something important. If your Cls table has more columns that id and name, try

C#

public JsonResult jsonClassList()
       {
           var classes = from c in db.Cls
                         select new {id = c.Id, name = c.name};
           return Json(new { Classes = classes }, JsonRequestBehavior.AllowGet);
       }