Deserialize json object into SQL DB using Json.net

Question

I want to deserialize json object into SQL DB using Json.net

Json File :

{
  "requirements": {
    "requirement": [
      {
        "Id": "req1",
        "desc": "description of requirement1"
      },
      {
        "Id": "req2",
        "desc": "description of requirement2",
      },
      {
        "desc": "description of requirement3",
        "Id": "req3"
      }
    ]
  }
}

Such that values for 'Id' attribute should be places in ID column of Requirement table and values for 'desc' attribute should be places in DESC column of Requirement table

    ID        DESC
    req1      description of requirement1                       
    req2      description of requirement2                       
    req3      description of requirement3

You can also use OPENJSON in sql server, in case u are working with stored procedure . you can refer the link msdn.microsoft.com/en-in/library/dn921885.aspx — Priyank
– Priyank, Commented Nov 17, 2016 at 10:22

M. Wiśnicki · Accepted Answer · 2016-11-17 09:57:18Z

2

You can generate your class using json2sharp tool and use deserialize object like this.

    public class Requirement
    {
        public string Id { get; set; }
        public string desc { get; set; }
    }

    public class Requirements
    {
        public List<Requirement> requirement { get; set; }
    }

    public class RootObject
    {
        public Requirements requirements { get; set; }
    }


 var x =JsonConvert.DeserializeObject<RootObject>(json);

And use OrderByDescending

x.requirements.requirement.OrderByDescending(d => d.Id);

edited Nov 17, 2016 at 9:57

answered Nov 17, 2016 at 9:48

M. Wiśnicki

6,2133 gold badges25 silver badges28 bronze badges

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

Comments

Yanga · Accepted Answer · 2016-11-17 10:14:51Z

1

        string json = "{\"requirements\": {\"requirement\": [{\"Id\": \"req1\",\"desc\": \"description of requirement1\"},{\"Id\": \"req2\",\"desc\":\"description of requirement2\",},{\"desc\": \"description of requirement3\",\"Id\": \"req3\"}]}}";

        //Deserialize using Json.Net
        var objectRequirement = JsonConvert.DeserializeObject<RootObject>(json);

        //Add it to your database
        foreach (var item in objectRequirement.requirements.requirement)
        {
            db.Requirement.Add(new Requirement { ID = item.Id, DESC = item.desc });
        }
        db.SaveChanges();

U can use http://json2csharp.com/ to create your class:

    public class Requirement
    {
        public string Id { get; set; }
        public string desc { get; set; }
    }

    public class Requirements
    {
        public List<Requirement> requirement { get; set; }
    }

    public class RootObject
    {
        public Requirements requirements { get; set; }
    }

edited Nov 17, 2016 at 10:14

answered Nov 17, 2016 at 9:55

Yanga

3,0121 gold badge33 silver badges32 bronze badges

2 Comments

Programming Geek Over a year ago

I am getting below error for Foreach loop Error 28 foreach statement cannot operate on variables of type 'TestWebService.Models.RootObject' because 'TestWebService.Models.RootObject' does not contain a public definition for 'GetEnumerator' C:\Users\ab\Documents\Visual Studio 2013\Projects\TestWebService\TestWebService\Controllers\JsonReaderController.cs 82 17 TestWebService

Yanga Over a year ago

Ok i just replace (var item in objectRequirement) with (var item in objectRequirement.requirements.requirement), i also change the json string in my solution.

Collectives™ on Stack Overflow

Deserialize json object into SQL DB using Json.net

2 Answers 2

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related