在 C# 中将两个 JSON 结构合二为一

如果您的初始No Strata和多层测量结果实际上已经序列化为JSON 结构JContainer.Merge(Object, JsonMergeSettings)，您可以使用合并设置将它们简单地合并在一起MergeArrayHandling.Concat，如下所示：// Get the initial measurement JSON measurements as strings.IEnumerable<string> measturements = GetJsonMeasurements();// And concatenate them together into a combined `JObject`:var settings = new JsonMergeSettings { MergeArrayHandling = MergeArrayHandling.Concat };var json = measturements.Aggregate(new JObject(),                                   (j, s) => { j.Merge(JObject.Parse(s), settings); return j; });在这里，我假设测量值已经按"testTIN"值分组。如果没有，这很容易通过在聚合之前将所有结果解析为 aJObject并按值分组来添加"testTIN"，如下所示：var settings = new JsonMergeSettings { MergeArrayHandling = MergeArrayHandling.Concat };var json = measurements    .Select(j => JObject.Parse(j))    .GroupBy(j => (string)j["testTIN"])    .Select(g => g.Aggregate(new JObject(),                             (j1, j2) => { j1.Merge(j2, settings); return j1; })            )    .ToList();或者，如果您的 JSON 结果存储在某些文件集合中，您可以直接从文件中合并，如下所示：var settings = new JsonMergeSettings { MergeArrayHandling = MergeArrayHandling.Concat };var json = fileNames.Aggregate(new JObject(),                               (j, s) =>                                {                                    using (var file = File.OpenText(s))                                   using (var reader = new JsonTextReader(file))                                   {                                       j.Merge(JToken.Load(reader), settings);                                   }                                   return j;                                });演示在这里摆弄单元测试。更新如果您有一个可枚举的对象并希望通过将它们的 JSON 表示合并在一起来创建一个组合的 JSON 文件，您可以将每个对象投影到JObjectusing JObject.FromObject，然后合并它们：// Get the resultsIEnumerable<MeasurementSet__NoStrata> measurements1 = GetNoStrataMeasurements(); // Get no-strata measurements.IEnumerable<MeasurementSet__MultiStrata> measurements2 = GetMultiStrataMeasurements(); // Get multistrata measurements.// Combine them into a single enumerableIEnumerable<object> measurements = measurements1.Cast<object>()    .Concat(measurements2.Cast<object>());// Select serialization and merge settingsvar serializerSettings = new JsonSerializerSettings{    // Put whatever you want here, e.g.    NullValueHandling = NullValueHandling.Ignore,};var mergeSettings = new JsonMergeSettings {     // Required    MergeArrayHandling = MergeArrayHandling.Concat,    // Put whatever you want here, either Ignore or Merge    // https://www.newtonsoft.com/json/help/html/T_Newtonsoft_Json_Linq_MergeNullValueHandling.htm    MergeNullValueHandling = MergeNullValueHandling.Ignore, // Or Merge if you prefer};// Serialize and merge the resultsvar serializer = JsonSerializer.CreateDefault(serializerSettings);var json = measurements    .Select(m => JObject.FromObject(m, serializer))    .GroupBy(j => (string)j["testTIN"])    .Select(g => g.Aggregate(new JObject(),                             (j1, j2) => { j1.Merge(j2, mergeSettings); return j1; })            )    // Do we need to remove the `"category"` property?    // If so do it here.    .Select(o => { o.Remove("category"); return o; })    .ToList();演示小提琴＃2在这里。

在 C# 中将两个 JSON 结构合二为一

2回答