Returning JSON data to view page in ASP.NET MVC

Question

I'm working on MVC project and i using jQuery in view page to get data from controller.

public JsonResult CheckUpdate()
{
  dt = dt.AddSeconds(-100);

  IQueryable<Tweet> _tweet = ttr.CheckTime(dt);

  return Json(_tweet, JsonRequestBehavior.AllowGet);
}

This is a method in my controller which gets data back from the repository class and returns it as JSON to my view page, which uses jQuery to get it.

When i run program and inspect in Firebug, it shows me an error which is:

A circular reference was detected while serializing an object of type 'TweetTrafficReport.Models.User'

My question is

Is it correct that i return JSON data which it is IQueryable type
How can i use JSON data in my view page and not get an error like above

Thanks for ur help :)

MarkKGreenway · Accepted Answer · 2010-07-26 16:20:40Z

2

The circular reference i bet is because of the fact you have your Tweet object reference inReplyTo

IQueryable Really isnt as big an issue as casting each Tweet as a JsonCapableTweet like hanselman does http://nerddinnerbook.s3.amazonaws.com/Part11.htm

however it does help to lolok at the way Twitter does this

http://search.twitter.com/search.json?callback=foo&q=twitter

thats pretty nice json they return, matching yours to theirs is a good habit to have

answered Jul 26, 2010 at 16:20

MarkKGreenway

8,8046 gold badges36 silver badges53 bronze badges

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

2 Comments

icepon Over a year ago

Do you think that the circular reference problem come form what conflict in my database because i try and change belong NerdDinner ur given and it still be the circular reference problem

icepon Over a year ago

There is my false in my DB Thank you for ur help

amarsuperstar · Accepted Answer · 2010-07-26 15:47:59Z

2

You shouldn't really return IQueryable as Json, try returning a ViewModel instead

public JsonResult CheckUpdate()
{

   dt= dt.AddSeconds(-100);

   IQueryable<Tweet> _tweet = ttr.CheckTime(dt);

   var tweetVm = _tweet.Select(t => new TweetViewMode(){ Message = t.Message });

   return Json(tweetVm, JsonRequestBehavior.AllowGet);
}

answered Jul 26, 2010 at 15:47

amarsuperstar

1,8031 gold badge18 silver badges22 bronze badges

Collectives™ on Stack Overflow

Returning JSON data to view page in ASP.NET MVC

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related