c# - 使用 Json.net 将 json 对象反序列化为 SQL DB

Question

我想使用 Json.net 将 json 对象反序列化为 SQL DB

Json 文件:

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

“Id”属性的值应该放在需求表的 ID 列中，“desc”属性的值应该放在需求表的 DESC 列中

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

Answer 1

您可以使用 json2sharp 生成您的类工具并像这样使用反序列化对象。

    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);

并使用OrderByDescending

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