sqltojson | C# Online Compiler

sqltojson by gocolius

// Dapper Plus
// Doc: https://dapper-tutorial.net/query

// @nuget: Dapper -Version 1.60.6
using Newtonsoft.Json;   
using Dapper;
using System;
using System.Data.SqlClient;
					
public class Program
{	 
	public class OrderDetail
	{
		public int OrderDetailID { get; set; }
		public int OrderID { get; set; }
		public int ProductID { get; set; }
		public int Quantity { get; set; }
	}
	
	public static void Main()
	{
		string sql = "SELECT OrderID, Quantity FROM OrderDetails FOR JSON PATH, root ('Orders'), INCLUDE_NULL_VALUES";

		using (var connection = new SqlConnection(FiddleHelper.GetConnectionStringSqlServerW3Schools()))
		{	
			dynamic orderDetail = connection.Query<string>(sql);
			orderDetail = JsonConvert.SerializeObject(orderDetail,Formatting.Indented); 
		    Console.WriteLine(orderDetail);		
		}
	}
}

​x
 
// Dapper Plus
// Doc: https://dapper-tutorial.net/query
​
// @nuget: Dapper -Version 1.60.6
using Newtonsoft.Json;   
using Dapper;
using System;
using System.Data.SqlClient;
                    
public class Program
{    
    public class OrderDetail
    {
        public int OrderDetailID { get; set; }
        public int OrderID { get; set; }
        public int ProductID { get; set; }
        public int Quantity { get; set; }
    }
    
    public static void Main()
    {
        string sql = "SELECT OrderID, Quantity FROM OrderDetails FOR JSON PATH, root ('Orders'), INCLUDE_NULL_VALUES";
​
        using (var connection = new SqlConnection(FiddleHelper.GetConnectionStringSqlServerW3Schools()))
        {   
            dynamic orderDetail = connection.Query<string>(sql);
            orderDetail = JsonConvert.SerializeObject(orderDetail,Formatting.Indented); 
            Console.WriteLine(orderDetail);     
        }
    }
}

[
  "{\"Orders\":[{\"OrderID\":10248,\"Quantity\":12},{\"OrderID\":10248,\"Quantity\":10},{\"OrderID\":10248,\"Quantity\":5},{\"OrderID\":10249,\"Quantity\":9},{\"OrderID\":10249,\"Quantity\":40},{\"OrderID\":10250,\"Quantity\":10},{\"OrderID\":10250,\"Quantity\":35},{\"OrderID\":10250,\"Quantity\":15},{\"OrderID\":10251,\"Quantity\":6},{\"OrderID\":10251,\"Quantity\":15},{\"OrderID\":10251,\"Quantity\":20},{\"OrderID\":10252,\"Quantity\":40},{\"OrderID\":10252,\"Quantity\":25},{\"OrderID\":10252,\"Quantity\":40},{\"OrderID\":10253,\"Quantity\":20},{\"OrderID\":10253,\"Quantity\":42},{\"OrderID\":10253,\"Quantity\":40},{\"OrderID\":10254,\"Quantity\":15},{\"OrderID\":10254,\"Quantity\":21},{\"OrderID\":10254,\"Quantity\":21},{\"OrderID\":10255,\"Quantity\":20},{\"OrderID\":10255,\"Quantity\":35},{\"OrderID\":10255,\"Quantity\":25},{\"OrderID\":10255,\"Quantity\":30},{\"OrderID\":10256,\"Quantity\":15},{\"OrderID\":10256,\"Quantity\":12},{\"OrderID\":10257,\"Quantity\":25},{\"OrderID\":10257,\"Quantity\":6},{\"OrderID\":10257,\"Quantity\":15},{\"OrderID\":10258,\"Quantity\":50},{\"OrderID\":10258,\"Quantity\":65},{\"OrderID\":10258,\"Quantity\":6},{\"OrderID\":10259,\"Quantity\":10},{\"OrderID\":10259,\"Quantity\":1},{\"OrderID\":10260,\"Quantity\":16},{\"OrderID\":10260,\"Quantity\":50},{\"OrderID\":10260,\"Quantity\":15},{\"OrderID\":10260,\"Quantity\":21},{\"OrderID\":10261,\"Quantity\":20},{\"OrderID\":10261,\"Quantity\":20},{\"OrderID\":10262,\"Quantity\":12},{\"OrderID\":10262,\"Quantity\":15},{\"OrderID\":10262,\"Quantity\":2},{\"OrderID\":10263,\"Quantity\":60},{\"OrderID\":10263,\"Quantity\":28},{\"OrderID\":10263,\"Quantity\":60},{\"OrderID\":10263,\"Quantity\":36},{\"OrderID\":10264,\"Quantity\":35},{\"OrderID\":10264,\"Quantity\":25},{\"OrderID\":10265,\"Quantity\":30},{\"OrderID\":10265,\"Quantity\":20},{\"OrderID\":10266,\"Quantity\":12},{\"OrderID\":10267,\"Quantity\":50},{\"OrderID\":10267,\"Quantity\":70},{\"OrderID\":10267,\"Quantity\":15},{\"OrderID\":10268,\"Quantity\":10},{\"OrderID\":10268,\"Quantity\":4},{\"OrderID\":10269,\"Quantity\":60},{\"OrderID\":10269,\"Quantity\":20},{\"OrderID\":10270,\"Quantity\":30},{\"OrderID\":10270,\"Quantity\":25},{\"OrderID\":10271,\"Quantity\":24},{\"OrderID\":10272,\"Quantity\":6},{\"OrderID\":1027",
  "2,\"Quantity\":40},{\"OrderID\":10272,\"Quantity\":24},{\"OrderID\":10273,\"Quantity\":24},{\"OrderID\":10273,\"Quantity\":15},{\"OrderID\":10273,\"Quantity\":20},{\"OrderID\":10273,\"Quantity\":60},{\"OrderID\":10273,\"Quantity\":33},{\"OrderID\":10274,\"Quantity\":20},{\"OrderID\":10274,\"Quantity\":7},{\"OrderID\":10275,\"Quantity\":12},{\"OrderID\":10275,\"Quantity\":6},{\"OrderID\":10276,\"Quantity\":15},{\"OrderID\":10276,\"Quantity\":10},{\"OrderID\":10277,\"Quantity\":20},{\"OrderID\":10277,\"Quantity\":12},{\"OrderID\":10278,\"Quantity\":16},{\"OrderID\":10278,\"Quantity\":15},{\"OrderID\":10278,\"Quantity\":8},{\"OrderID\":10278,\"Quantity\":25},{\"OrderID\":10279,\"Quantity\":15},{\"OrderID\":10280,\"Quantity\":12},{\"OrderID\":10280,\"Quantity\":20},{\"OrderID\":10280,\"Quantity\":30},{\"OrderID\":10281,\"Quantity\":1},{\"OrderID\":10281,\"Quantity\":6},{\"OrderID\":10281,\"Quantity\":4},{\"OrderID\":10282,\"Quantity\":6},{\"OrderID\":10282,\"Quantity\":2},{\"OrderID\":10283,\"Quantity\":20},{\"OrderID\":10283,\"Quantity\":18},{\"OrderID\":10283,\"Quantity\":35},{\"OrderID\":10283,\"Quantity\":3},{\"OrderID\":10284,\"Quantity\":15},{\"OrderID\":10284,\"Quantity\":21},{\"OrderID\":10284,\"Quantity\":20},{\"OrderID\":10284,\"Quantity\":5},{\"OrderID\":10285,\"Quantity\":45},{\"OrderID\":10285,\"Quantity\":40},{\"OrderID\":10285,\"Quantity\":36},{\"OrderID\":10286,\"Quantity\":100},{\"OrderID\":10286,\"Quantity\":40},{\"OrderID\":10287,\"Quantity\":40},{\"OrderID\":10287,\"Quantity\":20},{\"OrderID\":10287,\"Quantity\":15},{\"OrderID\":10288,\"Quantity\":10},{\"OrderID\":10288,\"Quantity\":3},{\"OrderID\":10289,\"Quantity\":30},{\"OrderID\":10289,\"Quantity\":9},{\"OrderID\":10290,\"Quantity\":20},{\"OrderID\":10290,\"Quantity\":15},{\"OrderID\":10290,\"Quantity\":15},{\"OrderID\":10290,\"Quantity\":10},{\"OrderID\":10291,\"Quantity\":20},{\"OrderID\":10291,\"Quantity\":24},{\"OrderID\":10291,\"Quantity\":2},{\"OrderID\":10292,\"Quantity\":20},{\"OrderID\":10293,\"Quantity\":12},{\"OrderID\":10293,\"Quantity\":10},{\"OrderID\":10293,\"Quantity\":5},{\"OrderID\":10293,\"Quantity\":6},{\"OrderID\":10294,\"Quantity\":18},{\"OrderID\":10294,\"Quantity\":15},{\"OrderID\":10294,\"Quantity\":15},{\"OrderID\":10294,\"Quantity\":21},{\"OrderID\":102",
  "94,\"Quantity\":6},{\"OrderID\":10295,\"Quantity\":4},{\"OrderID\":10296,\"Quantity\":12},{\"OrderID\":10296,\"Quantity\":30},{\"OrderID\":10296,\"Quantity\":15},{\"OrderID\":10297,\"Quantity\":60},{\"OrderID\":10297,\"Quantity\":20},{\"OrderID\":10298,\"Quantity\":40},{\"OrderID\":10298,\"Quantity\":40},{\"OrderID\":10298,\"Quantity\":30},{\"OrderID\":10298,\"Quantity\":15},{\"OrderID\":10299,\"Quantity\":15},{\"OrderID\":10299,\"Quantity\":20},{\"OrderID\":10300,\"Quantity\":30},{\"OrderID\":10300,\"Quantity\":20},{\"OrderID\":10301,\"Quantity\":10},{\"OrderID\":10301,\"Quantity\":20},{\"OrderID\":10302,\"Quantity\":40},{\"OrderID\":10302,\"Quantity\":28},{\"OrderID\":10302,\"Quantity\":12},{\"OrderID\":10303,\"Quantity\":40},{\"OrderID\":10303,\"Quantity\":30},{\"OrderID\":10303,\"Quantity\":15},{\"OrderID\":10304,\"Quantity\":30},{\"OrderID\":10304,\"Quantity\":10},{\"OrderID\":10304,\"Quantity\":2},{\"OrderID\":10305,\"Quantity\":25},{\"OrderID\":10305,\"Quantity\":25},{\"OrderID\":10305,\"Quantity\":30},{\"OrderID\":10306,\"Quantity\":10},{\"OrderID\":10306,\"Quantity\":10},{\"OrderID\":10306,\"Quantity\":5},{\"OrderID\":10307,\"Quantity\":10},{\"OrderID\":10307,\"Quantity\":3},{\"OrderID\":10308,\"Quantity\":1},{\"OrderID\":10308,\"Quantity\":5},{\"OrderID\":10309,\"Quantity\":20},{\"OrderID\":10309,\"Quantity\":30},{\"OrderID\":10309,\"Quantity\":2},{\"OrderID\":10309,\"Quantity\":20},{\"OrderID\":10309,\"Quantity\":3},{\"OrderID\":10310,\"Quantity\":10},{\"OrderID\":10310,\"Quantity\":5},{\"OrderID\":10311,\"Quantity\":6},{\"OrderID\":10311,\"Quantity\":7},{\"OrderID\":10312,\"Quantity\":4},{\"OrderID\":10312,\"Quantity\":24},{\"OrderID\":10312,\"Quantity\":20},{\"OrderID\":10312,\"Quantity\":10},{\"OrderID\":10313,\"Quantity\":12},{\"OrderID\":10314,\"Quantity\":40},{\"OrderID\":10314,\"Quantity\":30},{\"OrderID\":10314,\"Quantity\":25},{\"OrderID\":10315,\"Quantity\":14},{\"OrderID\":10315,\"Quantity\":30},{\"OrderID\":10316,\"Quantity\":10},{\"OrderID\":10316,\"Quantity\":70},{\"OrderID\":10317,\"Quantity\":20},{\"OrderID\":10318,\"Quantity\":20},{\"OrderID\":10318,\"Quantity\":6},{\"OrderID\":10319,\"Quantity\":8},{\"OrderID\":10319,\"Quantity\":14},{\"OrderID\":10319,\"Quantity\":30},{\"OrderID\":10320,\"Quantity\":30},{\"OrderID\":103",
  "21,\"Quantity\":10},{\"OrderID\":10322,\"Quantity\":20},{\"OrderID\":10323,\"Quantity\":5},{\"OrderID\":10323,\"Quantity\":4},{\"OrderID\":10323,\"Quantity\":4},{\"OrderID\":10324,\"Quantity\":21},{\"OrderID\":10324,\"Quantity\":70},{\"OrderID\":10324,\"Quantity\":30},{\"OrderID\":10324,\"Quantity\":40},{\"OrderID\":10324,\"Quantity\":80},{\"OrderID\":10325,\"Quantity\":6},{\"OrderID\":10325,\"Quantity\":12},{\"OrderID\":10325,\"Quantity\":9},{\"OrderID\":10325,\"Quantity\":4},{\"OrderID\":10325,\"Quantity\":40},{\"OrderID\":10326,\"Quantity\":24},{\"OrderID\":10326,\"Quantity\":16},{\"OrderID\":10326,\"Quantity\":50},{\"OrderID\":10327,\"Quantity\":25},{\"OrderID\":10327,\"Quantity\":50},{\"OrderID\":10327,\"Quantity\":35},{\"OrderID\":10327,\"Quantity\":30},{\"OrderID\":10328,\"Quantity\":9},{\"OrderID\":10328,\"Quantity\":40},{\"OrderID\":10328,\"Quantity\":10},{\"OrderID\":10329,\"Quantity\":10},{\"OrderID\":10329,\"Quantity\":8},{\"OrderID\":10329,\"Quantity\":20},{\"OrderID\":10329,\"Quantity\":12},{\"OrderID\":10330,\"Quantity\":50},{\"OrderID\":10330,\"Quantity\":25},{\"OrderID\":10331,\"Quantity\":15},{\"OrderID\":10332,\"Quantity\":40},{\"OrderID\":10332,\"Quantity\":10},{\"OrderID\":10332,\"Quantity\":16},{\"OrderID\":10333,\"Quantity\":10},{\"OrderID\":10333,\"Quantity\":10},{\"OrderID\":10333,\"Quantity\":40},{\"OrderID\":10334,\"Quantity\":8},{\"OrderID\":10334,\"Quantity\":10},{\"OrderID\":10335,\"Quantity\":7},{\"OrderID\":10335,\"Quantity\":25},{\"OrderID\":10335,\"Quantity\":6},{\"OrderID\":10335,\"Quantity\":48},{\"OrderID\":10336,\"Quantity\":18},{\"OrderID\":10337,\"Quantity\":40},{\"OrderID\":10337,\"Quantity\":24},{\"OrderID\":10337,\"Quantity\":20},{\"OrderID\":10337,\"Quantity\":28},{\"OrderID\":10337,\"Quantity\":25},{\"OrderID\":10338,\"Quantity\":20},{\"OrderID\":10338,\"Quantity\":15},{\"OrderID\":10339,\"Quantity\":10},{\"OrderID\":10339,\"Quantity\":70},{\"OrderID\":10339,\"Quantity\":28},{\"OrderID\":10340,\"Quantity\":20},{\"OrderID\":10340,\"Quantity\":12},{\"OrderID\":10340,\"Quantity\":40},{\"OrderID\":10341,\"Quantity\":8},{\"OrderID\":10341,\"Quantity\":9},{\"OrderID\":10342,\"Quantity\":24},{\"OrderID\":10342,\"Quantity\":56},{\"OrderID\":10342,\"Quantity\":40},{\"OrderID\":10342,\"Quantity\":40},{\"OrderID\":1",
  "0343,\"Quantity\":50},{\"OrderID\":10343,\"Quantity\":4},{\"OrderID\":10343,\"Quantity\":15},{\"OrderID\":10344,\"Quantity\":35},{\"OrderID\":10344,\"Quantity\":70},{\"OrderID\":10345,\"Quantity\":70},{\"OrderID\":10345,\"Quantity\":80},{\"OrderID\":10345,\"Quantity\":9},{\"OrderID\":10346,\"Quantity\":36},{\"OrderID\":10346,\"Quantity\":20},{\"OrderID\":10347,\"Quantity\":10},{\"OrderID\":10347,\"Quantity\":50},{\"OrderID\":10347,\"Quantity\":4},{\"OrderID\":10347,\"Quantity\":6},{\"OrderID\":10348,\"Quantity\":15},{\"OrderID\":10348,\"Quantity\":25},{\"OrderID\":10349,\"Quantity\":24},{\"OrderID\":10350,\"Quantity\":15},{\"OrderID\":10350,\"Quantity\":18},{\"OrderID\":10351,\"Quantity\":20},{\"OrderID\":10351,\"Quantity\":13},{\"OrderID\":10351,\"Quantity\":77},{\"OrderID\":10351,\"Quantity\":10},{\"OrderID\":10352,\"Quantity\":10},{\"OrderID\":10352,\"Quantity\":20},{\"OrderID\":10353,\"Quantity\":12},{\"OrderID\":10353,\"Quantity\":50},{\"OrderID\":10354,\"Quantity\":12},{\"OrderID\":10354,\"Quantity\":4},{\"OrderID\":10355,\"Quantity\":25},{\"OrderID\":10355,\"Quantity\":25},{\"OrderID\":10356,\"Quantity\":30},{\"OrderID\":10356,\"Quantity\":12},{\"OrderID\":10356,\"Quantity\":20},{\"OrderID\":10357,\"Quantity\":30},{\"OrderID\":10357,\"Quantity\":16},{\"OrderID\":10357,\"Quantity\":8},{\"OrderID\":10358,\"Quantity\":10},{\"OrderID\":10358,\"Quantity\":10},{\"OrderID\":10358,\"Quantity\":20},{\"OrderID\":10359,\"Quantity\":56},{\"OrderID\":10359,\"Quantity\":70},{\"OrderID\":10359,\"Quantity\":80},{\"OrderID\":10360,\"Quantity\":30},{\"OrderID\":10360,\"Quantity\":35},{\"OrderID\":10360,\"Quantity\":10},{\"OrderID\":10360,\"Quantity\":35},{\"OrderID\":10360,\"Quantity\":28},{\"OrderID\":10361,\"Quantity\":54},{\"OrderID\":10361,\"Quantity\":55},{\"OrderID\":10362,\"Quantity\":50},{\"OrderID\":10362,\"Quantity\":20},{\"OrderID\":10362,\"Quantity\":24},{\"OrderID\":10363,\"Quantity\":20},{\"OrderID\":10363,\"Quantity\":12},{\"OrderID\":10363,\"Quantity\":12},{\"OrderID\":10364,\"Quantity\":30},{\"OrderID\":10364,\"Quantity\":5},{\"OrderID\":10365,\"Quantity\":24},{\"OrderID\":10366,\"Quantity\":5},{\"OrderID\":10366,\"Quantity\":5},{\"OrderID\":10367,\"Quantity\":36},{\"OrderID\":10367,\"Quantity\":18},{\"OrderID\":10367,\"Quantity\":15},{\"Orde",
  "rID\":10367,\"Quantity\":7},{\"OrderID\":10368,\"Quantity\":5},{\"OrderID\":10368,\"Quantity\":13},{\"OrderID\":10368,\"Quantity\":25},{\"OrderID\":10368,\"Quantity\":35},{\"OrderID\":10369,\"Quantity\":20},{\"OrderID\":10369,\"Quantity\":18},{\"OrderID\":10370,\"Quantity\":15},{\"OrderID\":10370,\"Quantity\":30},{\"OrderID\":10370,\"Quantity\":20},{\"OrderID\":10371,\"Quantity\":6},{\"OrderID\":10372,\"Quantity\":12},{\"OrderID\":10372,\"Quantity\":40},{\"OrderID\":10372,\"Quantity\":70},{\"OrderID\":10372,\"Quantity\":42},{\"OrderID\":10373,\"Quantity\":80},{\"OrderID\":10373,\"Quantity\":50},{\"OrderID\":10374,\"Quantity\":30},{\"OrderID\":10374,\"Quantity\":15},{\"OrderID\":10375,\"Quantity\":15},{\"OrderID\":10375,\"Quantity\":10},{\"OrderID\":10376,\"Quantity\":42},{\"OrderID\":10377,\"Quantity\":20},{\"OrderID\":10377,\"Quantity\":20},{\"OrderID\":10378,\"Quantity\":6},{\"OrderID\":10379,\"Quantity\":8},{\"OrderID\":10379,\"Quantity\":16},{\"OrderID\":10379,\"Quantity\":20},{\"OrderID\":10380,\"Quantity\":18},{\"OrderID\":10380,\"Quantity\":20},{\"OrderID\":10380,\"Quantity\":6},{\"OrderID\":10380,\"Quantity\":30},{\"OrderID\":10381,\"Quantity\":14},{\"OrderID\":10382,\"Quantity\":32},{\"OrderID\":10382,\"Quantity\":9},{\"OrderID\":10382,\"Quantity\":14},{\"OrderID\":10382,\"Quantity\":60},{\"OrderID\":10382,\"Quantity\":50},{\"OrderID\":10383,\"Quantity\":20},{\"OrderID\":10383,\"Quantity\":15},{\"OrderID\":10383,\"Quantity\":20},{\"OrderID\":10384,\"Quantity\":28},{\"OrderID\":10384,\"Quantity\":15},{\"OrderID\":10385,\"Quantity\":10},{\"OrderID\":10385,\"Quantity\":20},{\"OrderID\":10385,\"Quantity\":8},{\"OrderID\":10386,\"Quantity\":15},{\"OrderID\":10386,\"Quantity\":10},{\"OrderID\":10387,\"Quantity\":15},{\"OrderID\":10387,\"Quantity\":6},{\"OrderID\":10387,\"Quantity\":12},{\"OrderID\":10387,\"Quantity\":15},{\"OrderID\":10388,\"Quantity\":15},{\"OrderID\":10388,\"Quantity\":20},{\"OrderID\":10388,\"Quantity\":40},{\"OrderID\":10389,\"Quantity\":16},{\"OrderID\":10389,\"Quantity\":15},{\"OrderID\":10389,\"Quantity\":20},{\"OrderID\":10389,\"Quantity\":30},{\"OrderID\":10390,\"Quantity\":60},{\"OrderID\":10390,\"Quantity\":40},{\"OrderID\":10390,\"Quantity\":45},{\"OrderID\":10390,\"Quantity\":24},{\"OrderID\":10391,\"Quantity\":18},",
  "{\"OrderID\":10392,\"Quantity\":50},{\"OrderID\":10393,\"Quantity\":25},{\"OrderID\":10393,\"Quantity\":42},{\"OrderID\":10393,\"Quantity\":7},{\"OrderID\":10393,\"Quantity\":70},{\"OrderID\":10393,\"Quantity\":32},{\"OrderID\":10394,\"Quantity\":10},{\"OrderID\":10394,\"Quantity\":10},{\"OrderID\":10395,\"Quantity\":28},{\"OrderID\":10395,\"Quantity\":70},{\"OrderID\":10395,\"Quantity\":8},{\"OrderID\":10396,\"Quantity\":40},{\"OrderID\":10396,\"Quantity\":60},{\"OrderID\":10396,\"Quantity\":21},{\"OrderID\":10397,\"Quantity\":10},{\"OrderID\":10397,\"Quantity\":18},{\"OrderID\":10398,\"Quantity\":30},{\"OrderID\":10398,\"Quantity\":120},{\"OrderID\":10399,\"Quantity\":60},{\"OrderID\":10399,\"Quantity\":30},{\"OrderID\":10399,\"Quantity\":35},{\"OrderID\":10399,\"Quantity\":14},{\"OrderID\":10400,\"Quantity\":21},{\"OrderID\":10400,\"Quantity\":35},{\"OrderID\":10400,\"Quantity\":30},{\"OrderID\":10401,\"Quantity\":18},{\"OrderID\":10401,\"Quantity\":70},{\"OrderID\":10401,\"Quantity\":20},{\"OrderID\":10401,\"Quantity\":60},{\"OrderID\":10402,\"Quantity\":60},{\"OrderID\":10402,\"Quantity\":65},{\"OrderID\":10403,\"Quantity\":21},{\"OrderID\":10403,\"Quantity\":70},{\"OrderID\":10404,\"Quantity\":30},{\"OrderID\":10404,\"Quantity\":40},{\"OrderID\":10404,\"Quantity\":30},{\"OrderID\":10405,\"Quantity\":50},{\"OrderID\":10406,\"Quantity\":10},{\"OrderID\":10406,\"Quantity\":30},{\"OrderID\":10406,\"Quantity\":42},{\"OrderID\":10406,\"Quantity\":5},{\"OrderID\":10406,\"Quantity\":2},{\"OrderID\":10407,\"Quantity\":30},{\"OrderID\":10407,\"Quantity\":15},{\"OrderID\":10407,\"Quantity\":15},{\"OrderID\":10408,\"Quantity\":10},{\"OrderID\":10408,\"Quantity\":6},{\"OrderID\":10408,\"Quantity\":35},{\"OrderID\":10409,\"Quantity\":12},{\"OrderID\":10409,\"Quantity\":12},{\"OrderID\":10410,\"Quantity\":49},{\"OrderID\":10410,\"Quantity\":16},{\"OrderID\":10411,\"Quantity\":25},{\"OrderID\":10411,\"Quantity\":40},{\"OrderID\":10411,\"Quantity\":9},{\"OrderID\":10412,\"Quantity\":20},{\"OrderID\":10413,\"Quantity\":24},{\"OrderID\":10413,\"Quantity\":40},{\"OrderID\":10413,\"Quantity\":14},{\"OrderID\":10414,\"Quantity\":18},{\"OrderID\":10414,\"Quantity\":50},{\"OrderID\":10415,\"Quantity\":2},{\"OrderID\":10415,\"Quantity\":20},{\"OrderID\":10416,\"Quant",
  "ity\":20},{\"OrderID\":10416,\"Quantity\":10},{\"OrderID\":10416,\"Quantity\":20},{\"OrderID\":10417,\"Quantity\":50},{\"OrderID\":10417,\"Quantity\":2},{\"OrderID\":10417,\"Quantity\":36},{\"OrderID\":10417,\"Quantity\":35},{\"OrderID\":10418,\"Quantity\":60},{\"OrderID\":10418,\"Quantity\":55},{\"OrderID\":10418,\"Quantity\":16},{\"OrderID\":10418,\"Quantity\":15},{\"OrderID\":10419,\"Quantity\":60},{\"OrderID\":10419,\"Quantity\":20},{\"OrderID\":10420,\"Quantity\":20},{\"OrderID\":10420,\"Quantity\":2},{\"OrderID\":10420,\"Quantity\":8},{\"OrderID\":10420,\"Quantity\":20},{\"OrderID\":10421,\"Quantity\":4},{\"OrderID\":10421,\"Quantity\":30},{\"OrderID\":10421,\"Quantity\":15},{\"OrderID\":10421,\"Quantity\":10},{\"OrderID\":10422,\"Quantity\":2},{\"OrderID\":10423,\"Quantity\":14},{\"OrderID\":10423,\"Quantity\":20},{\"OrderID\":10424,\"Quantity\":60},{\"OrderID\":10424,\"Quantity\":49},{\"OrderID\":10424,\"Quantity\":30},{\"OrderID\":10425,\"Quantity\":10},{\"OrderID\":10425,\"Quantity\":20},{\"OrderID\":10426,\"Quantity\":5},{\"OrderID\":10426,\"Quantity\":7},{\"OrderID\":10427,\"Quantity\":35},{\"OrderID\":10428,\"Quantity\":20},{\"OrderID\":10429,\"Quantity\":40},{\"OrderID\":10429,\"Quantity\":35},{\"OrderID\":10430,\"Quantity\":45},{\"OrderID\":10430,\"Quantity\":50},{\"OrderID\":10430,\"Quantity\":30},{\"OrderID\":10430,\"Quantity\":70},{\"OrderID\":10431,\"Quantity\":50},{\"OrderID\":10431,\"Quantity\":50},{\"OrderID\":10431,\"Quantity\":30},{\"OrderID\":10432,\"Quantity\":10},{\"OrderID\":10432,\"Quantity\":40},{\"OrderID\":10433,\"Quantity\":28},{\"OrderID\":10434,\"Quantity\":6},{\"OrderID\":10434,\"Quantity\":18},{\"OrderID\":10435,\"Quantity\":10},{\"OrderID\":10435,\"Quantity\":12},{\"OrderID\":10435,\"Quantity\":10},{\"OrderID\":10436,\"Quantity\":5},{\"OrderID\":10436,\"Quantity\":40},{\"OrderID\":10436,\"Quantity\":30},{\"OrderID\":10436,\"Quantity\":24},{\"OrderID\":10437,\"Quantity\":15},{\"OrderID\":10438,\"Quantity\":15},{\"OrderID\":10438,\"Quantity\":20},{\"OrderID\":10438,\"Quantity\":15},{\"OrderID\":10439,\"Quantity\":15},{\"OrderID\":10439,\"Quantity\":16},{\"OrderID\":10439,\"Quantity\":6},{\"OrderID\":10439,\"Quantity\":30},{\"OrderID\":10440,\"Quantity\":45},{\"OrderID\":10440,\"Quantity\":49},{\"OrderID\":10440,\"",
  "Quantity\":24},{\"OrderID\":10440,\"Quantity\":90},{\"OrderID\":10441,\"Quantity\":50},{\"OrderID\":10442,\"Quantity\":30},{\"OrderID\":10442,\"Quantity\":80},{\"OrderID\":10442,\"Quantity\":60},{\"OrderID\":10443,\"Quantity\":6},{\"OrderID\":10443,\"Quantity\":12}]}"
]

Cached Result
Last Run:	2:28:15 am
Compile:	0.219s
Execute:	0.49s
Memory:	43.09Mb
CPU:	0.709s

View IL Code