How to return complex Json object in asp.net mvc

Question

I am using entity framework to get data from database and serialize it to JSON. And I want my JSON response looks like the one below. Shoud I add items property to my model and make JSON I want? Thanks.

Desired Json

{
      "items" : [
        {
          "Id": 1,
          "AdContent":"Content1"
        },
        {
          "Id": 2,
          "AdContent":"Content2"
        },
        {
          "Id": 3,
          "AdContent":"Content3"
        }   
      ]
}

Current JSON I receive

[
    {
        "Id":1,
        "AdContent":"Content1"
    },
    {
         "Id":2,
         "AdContent":"Content2"
    },
    { 
         "Id":3,
         "AdContent":"Content3"
    }
]

{

Controller

public JsonResult GetJson()
{
     using (var db = new DoskaUsContext())
     {
         List<AdViewModel> list = db.Ads.Select(x => new AdViewModel
         {
             Id = x.AdId,                    
             AdContent = x.AdContent
         }).ToList();

         return Json(list, JsonRequestBehavior.AllowGet);
     }
}

Model

 public class AdViewModel
    {
        public int Id { get; set; }
        public string AdContent { get; set; }        
    }

return Json(new { items = list }, JsonRequestBehavior.AllowGet); — user3559349
– user3559349, Commented Aug 23, 2016 at 3:46

Alexei Levenkov · Accepted Answer · 2016-08-23 03:49:31Z

4

Anonymous object is one solution Json(new {items=list},...).

General approach to solve that problem - generate strongly typed classes with http://json2csharp.com/ and populate result via generated classes or at least see what is missing from your code.

In this particular case generated code:

public class Item
{
    public int Id { get; set; }
    public string AdContent { get; set; }
}

public class RootObject
{
    public List<Item> items { get; set; }
}

Which shows missing piece of the puzzle - RootObject with list property items.

answered Aug 23, 2016 at 3:49

Alexei Levenkov

101k15 gold badges138 silver badges189 bronze badges

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

Comments

Mostafiz · Accepted Answer · 2016-08-23 03:55:13Z

1

Create another model which hold collection of AdViewModel as items

 public class AdViewModel
    {
        public int Id { get; set; }
        public string AdContent { get; set; }        
    }

 public class NewModel
    {
        public AdViewModel items { get; set; }
    }

answered Aug 23, 2016 at 3:55

Mostafiz

7,3523 gold badges30 silver badges42 bronze badges

1 Comment

B Kansara Over a year ago

Okay i create with as you say, but what next?I have same problem?

Collectives™ on Stack Overflow

How to return complex Json object in asp.net mvc

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related