using System;

using System.Collections;

using System.Collections.Generic;

using System.Linq;

using System.Text;

using System.Data;

​

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/73626984/using-a-variable-in-jtoken-query

​

    class TestClass

    {

        public static void Test()

        {

            Test1();

            Test2();

            TestThatSelectTokenThrowsOnMultipleMatches();

        }

        public static void Test1()

        {

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

​

            var query = "$..Products[?(@.Name == 'AAA' || @.Name == 'BBB' || @.Name == 'CCC')].Price";

            var prices = o.SelectTokens(query);

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

​

            Assert.AreEqual("[10.01,30.03]", JsonConvert.SerializeObject(prices, Formatting.None));

        }   

​

        public static void Test2()

        {

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

​

            var names = new []{ "AAA", "BBB", "CCC" }; // Or whatever

            var query = names.Select((n, i) => (n, i))

                .Aggregate(new StringBuilder("$..Products[?("), 

                           (sb, p) => sb.Append(p.i == 0 ? "" : "||").Append("@.Name=='").Append(p.n).Append("'"))

                .Append(")].Price")

                .ToString();

            var prices = o.SelectTokens(query);

            Console.WriteLine(query);

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

​

            Assert.AreEqual("[10.01,30.03]", JsonConvert.SerializeObject(prices, Formatting.None));

        }   

​

        static void TestThatSelectTokenThrowsOnMultipleMatches()

        {

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

​

            var query = "$..Products[?(@.Name == 'AAA' || @.Name == 'BBB' || @.Name == 'CCC')].Price";

            Assert.Throws<JsonException>(() => o.SelectToken(query));

        }

        static string GetJson() => @"{

""Products"" : [

        {""Name"" : ""AAA"", ""Price"":10.01},

        {""Name"" : ""DDD"", ""Price"":20.02},

        {""Name"" : ""CCC"", ""Price"":30.03}

]

}";

    }

​

    public class Program

    {

        public static void Main()

        {

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

            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;

            }

        }

    }

​