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/59568060/how-to-query-multiple-fields-with-selecttokens

​

    class TestClass

    {

        public static void Test()

        {

            TestArraySlice(GetJson());

            TestSelect(GetJson());

            TestSelectWithNestedArraySlice(GetJson());

        }

​

        static void TestArraySlice(string json)

        {

            Console.WriteLine("Array slice results:");

​

            var data = JToken.Parse(GetJson());

​

            var query = data.SelectTokens("Values[*]['Name','Address']")

                .Select(v => (JProperty)v.Parent) // Get parent JProperty (which encapsulates name as well as value)

                .GroupBy(p => p.Parent)           // Group by parent JObject

                .Select(g => new JObject(g));     // Create a new object with the filtered properties

​

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

        }

​

        static void TestSelect(string json)

        {

            Console.WriteLine("Select results:");

​

            var data = JToken.Parse(GetJson());

​

            var query = data.SelectTokens("Values[*]")

                .OfType<JObject>()

                .Select(o => new JObject(o.Property("Name"), o.Property("Address")));

​

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

        }

​

        static void TestSelectWithNestedArraySlice(string json)

        {

            Console.WriteLine("Select with nested array slice results:");

​

            var data = JToken.Parse(GetJson());

​

            var query = data.SelectTokens("Values[*]")

                .Select(o => new JObject(o.SelectTokens("['Name','Address']").Select(v => (JProperty)v.Parent)));

​

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

        }

​

        static string GetJson()

        {

            var json = @"{ 

  ""Values"": [

    {

      ""Name"": ""Bill"",

      ""Age"": ""25"",

      ""Address"": ""1234 Easy St.""

    },

    {

      ""Name"": ""Bob"",

      ""Age"": ""28"",

      ""Address"": ""1600 Pennsylvania Ave.""

    },

    {

      ""Name"": ""Joe"",

      ""Age"": ""31"",

      ""Address"": ""653 28th St NW""

    }

  ]

}

";

            return json;

        }

    }

​

    public class Program

    {

        public static void Main()

        {

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

            Console.WriteLine("Json.NET version: " + 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.CodeBase.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;

        }

    }

​