将 JSON.NET JObject 的属性/标记转换为字典键

问题描述

我正在使用 JSON.NET 来解析来自 openexhangerates.org 服务器端的 JSON 响应.响应包含一个嵌套对象(rates")，其中包含一长串数字属性:

I'm using JSON.NET to parse a JSON reponse from openexhangerates.org server side using .NET. The response contains a nested object ("rates") which has a long list of numeric properties:

    {
    "disclaimer": "Exchange rates provided for informational purposes only, with no guarantee whatsoever of accuracy, validity, availability, or fitness for any purpose; use at your own risk. Other than that, have fun! Usage subject to acceptance of terms: http://openexchangerates.org/terms/",
    "license": "Data sourced from various providers with public-facing APIs; copyright may apply; not for resale; no warranties given. Usage subject to acceptance of license agreement: http://openexchangerates.org/license/",
        "timestamp": 1357268408,
        "base": "USD",
        "rates": {
            "AED": 3.673033,
            "AFN": 51.5663,
            "ALL": 106.813749,
            "AMD": 403.579996,
            etc...
        }
    }

属性名称对应于货币类型(例如USD").我需要假设属性列表会随着时间而改变，所以我想将对象转换为 Dictionary 而不是对应的 C# 对象.

The property names correspond to the currency type (e.g. "USD"). I need to assume that the list of properties can change over time, so I want to convert the object into a Dictionary instead of a corresponding C# object.

所以不要将 JSON 对象反序列化成这样的东西:

So instead of deserializing the JSON object into something like this:

class Rates
{
public decimal AED; // United Arab Emirates Dirham
public decimal AFN; // Afghan Afghani
public decimal ALL; // Albanian Lek
public decimal AMD; // Armenian Dram
// etc...
}

我想这样结束:

Dictionary<string,decimal>() {{"AED",0.2828},{"AFN",0.3373},{"ALL",2.2823},{"AMD",33.378} // etc...};

如何从响应字符串或调用 JObject.Parse(responseString) 生成的 JObject 开始?

How do I do this starting from either the response string or from the JObject produced by calling JObject.Parse(responseString)?

推荐答案

JObject 已经实现了 IDictionary，所以我怀疑当你导航到 rates 成员，您应该可以使用:

JObject already implements IDictionary<string, JToken>, so I suspect that when you've navigated down to the rates member, you should be able to use:

var result = rates.ToDictionary(pair => pair.Key, pair => (decimal) pair.Value);

不幸的是，它使用显式接口实现，这让这有点痛苦 - 但如果你通过 IDictionary 接口，那就没问题了.

Unfortunately it uses explicit interface implementation, which makes this a bit of a pain - but if you go via the IDictionary<string, JToken> interface, it's fine.

这是一个简短但完整的示例，它似乎适用于您提供的 JSON(保存到 test.json 文件中):

Here's a short but complete example which appears to work with the JSON you've provided (saved into a test.json file):

using System;
using System.Collections.Generic;
using System.IO;
using System.Linq;
using Newtonsoft.Json.Linq;

class Test
{
    static void Main()
    {
        JObject parsed = JObject.Parse(File.ReadAllText("test.json"));
        IDictionary<string, JToken> rates = (JObject) parsed["rates"];
        // Explicit typing just for "proof" here
        Dictionary<string, decimal> dictionary =
            rates.ToDictionary(pair => pair.Key,
                               pair => (decimal) pair.Value);
        Console.WriteLine(dictionary["ALL"]);
    }
}

这篇关于将 JSON.NET JObject 的属性/标记转换为字典键的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！