using System;

using System.Collections;

using System.Collections.Generic;

using System.Linq;

using System.Text;

using System.Runtime.Serialization.Formatters;

using System.IO;

using System.Data;

using System.ComponentModel.DataAnnotations;

using System.Globalization;

using System.Reflection;

using System.Collections.ObjectModel;

​

using Newtonsoft.Json;

using Newtonsoft.Json.Linq;

using Newtonsoft.Json.Converters;

using Newtonsoft.Json.Serialization;    

​

using NUnit.Framework; // Throws NUnit.Framework.AssertionException

​

//https://stackoverflow.com/questions/67774607/how-to-right-join-two-json-files-in-c

​

    class TestClass

    {

        public static void Test()

        {

            foreach (var categoriesJson in GetCategoriesJson())

            foreach (var itemsJson in GetItemsJson())

            {

                var catObj = JObject.Parse(categoriesJson);

                var ttObj = JObject.Parse(itemsJson);

​

                // Filter variables

                var gameVersions = new HashSet<string> { "A", "2" };

                var categoryIDs = new HashSet<string> { "metals" };

​

                // Left outer join on ttObj.  Select all Items[*] array items

                var query = from i in ttObj.SelectTokens("Items[*]").OfType<JObject>()

                    // Filter on the game version and category ID

                    let categoryId = (string)i["CategoryID"]           

                    let gameVersion = (string)i["GameVersion"]

                    where categoryIDs.Contains(categoryId) && gameVersions.Contains(gameVersion)

                    // Join with "Categories[*]" on category ID

                    join c in catObj.SelectTokens("Categories[*]") on categoryId equals (string)c["CategoryID"] into joined

                    // DefaultIfEmpty makes this a left join

                    from cat in joined.DefaultIfEmpty()               

                    // Select all records of i and add the CategoryDescription from cat.

                    select new JObject(i.Properties()) { new JProperty("CategoryDescription", cat?["CategoryDescription"]) };

​

                var results = query.ToList(); // Materialize the query into a list of results.

                Console.WriteLine(JsonConvert.SerializeObject(results, Formatting.Indented));

​

                Console.WriteLine();

            }

        }   

        static IEnumerable<string> GetItemsJson()

        {

            return new [] { 

                @"{

   ""Items"":[

      {

         ""CategoryID"":""crystalline"",

         ""TechName"":""Quartz"",

         ""SpawnID"":""quartz"",

         ""TechID"":1,

         ""GameVersion"":""A""

      },

      {

         ""CategoryID"":""metals"",

         ""TechName"":""Metal Salvage"",

         ""SpawnID"":""scrapmetal"",

         ""TechID"":2,

         ""GameVersion"":""A""

      },

      {

         ""CategoryID"":""outcrop"",

         ""TechName"":""Limestone Outcrop"",

         ""SpawnID"":""limestonechunk"",

         ""TechID"":4,

         ""GameVersion"":""A""

      }

      // Other items omitted

   ]

}",

                @"{

   ""Items"":[

      {

         ""CategoryID"":""crystalline"",

         ""TechName"":""Quartz"",

         ""SpawnID"":""quartz"",

         ""TechID"":1,

         ""GameVersion"":""A""

      },

      {

         ""CategoryID"":""metals"",

         ""TechName"":""Metal Salvage"",

         ""SpawnID"":""scrapmetal"",

         ""TechID"":2,

         ""GameVersion"":""A""

      },

      {

         ""CategoryID"":""outcrop"",

         ""TechName"":""Limestone Outcrop"",

         ""SpawnID"":""limestonechunk"",

         ""TechID"":4,

         ""GameVersion"":""A""

      },

      {

         ""CategoryID"":""metals"",

         ""TechName"":""Shiny Metal"",

         ""SpawnID"":""manufactured metal"",

         ""TechID"":2,

         ""GameVersion"":""A""

      },

   ]

}"

​

            };

        }

        static IEnumerable<string> GetCategoriesJson()

        {

            return new [] { @"{

   ""Categories"":[

      {

         ""CategoryID"":""baseupgrades"",

         ""CategoryDescription"":""Base Upgrades"",

         ""IncludeCategory"":true,

         ""GameVersion"":""A""

      },

      {

         ""CategoryID"":""batteries"",

         ""CategoryDescription"":""Batteries"",

         ""IncludeCategory"":true,

         ""GameVersion"":""A""

      },

      {

         ""CategoryID"":""blueprint"",

         ""CategoryDescription"":""Blueprint"",

         ""IncludeCategory"":false,

         ""GameVersion"":""A""

      }

      // Other category values omitted

   ]

}

",

                           @"{

   ""Categories"":[

      {

         ""CategoryID"":""baseupgrades"",

         ""CategoryDescription"":""Base Upgrades"",

         ""IncludeCategory"":true,

         ""GameVersion"":""A""

      },

      {

         ""CategoryID"":""batteries"",

         ""CategoryDescription"":""Batteries"",

         ""IncludeCategory"":true,

         ""GameVersion"":""A""

      },

      {

         ""CategoryID"":""metals"",

         ""CategoryDescription"":""metals description"",

         ""IncludeCategory"":false,

         ""GameVersion"":""A""

      },

      {

         ""CategoryID"":""metals"",

         ""CategoryDescription"":""metals description 2"",

         ""IncludeCategory"":false,

         ""GameVersion"":""A""

      }

      // Other category values omitted

   ]

}

",

                          };

        }

    }

​

    public class Program

    {

        public static void Main()

        {

            Console.WriteLine("Environment version: {0} ({1})", System.Runtime.InteropServices.RuntimeInformation.FrameworkDescription , GetNetCoreVersion());

            Console.WriteLine("{0} version: {1}", typeof(JsonSerializer).Assembly.GetName().Name,  typeof(JsonSerializer).Assembly.FullName);

            Console.WriteLine();

​

            try

            {

                TestClass.Test();

            }

            catch (Exception ex)

            {

                Console.WriteLine("Failed with unhandled exception: ");

                Console.WriteLine(ex);

                throw;

            }

        }

        public static string GetNetCoreVersion()

        {

            //https://techblog.dorogin.com/how-to-detect-net-core-version-in-runtime-ecd65ad695be

            //

            var assembly = typeof(System.Runtime.GCSettings).GetTypeInfo().Assembly;

            var assemblyPath = assembly.Location.Split(new[] { '/', '\\' }, StringSplitOptions.RemoveEmptyEntries);

            int netCoreAppIndex = Array.IndexOf(assemblyPath, "Microsoft.NETCore.App");

            if (netCoreAppIndex > 0 && netCoreAppIndex < assemblyPath.Length - 2)

                return assemblyPath[netCoreAppIndex + 1];

            return null;

        }

    }

​