[Fork] https://stackoverflow.com/questions/56211783/translate-c-sharp-to-vb-net#56211783

VbNet · Console

/Program.vb

Imports System
Imports System.Linq
Imports System.Collections
Imports System.Collections.Generic
Imports System.Data
Imports System.IO
Imports System.Globalization
Imports System.Reflection
Imports System.ComponentModel.DataAnnotations
Imports System.Xml.Linq
Imports System.Xml

Imports Newtonsoft.Json
Imports Newtonsoft.Json.Linq
Imports Newtonsoft.Json.Converters
Imports Newtonsoft.Json.Serialization

Imports Microsoft.VisualBasic 

Imports NUnit.Framework

	' https://stackoverflow.com/questions/56211783/translate-c-sharp-to-vb-net#56211783

	Public Module TestClass	

		Sub PrintType(Of T)(ByVal Item As T)
			Console.WriteLine(GetType(T))
		End Sub
	
		Friend Sub Test()
			Dim json as String = GetJson()
	
			Dim obj As JObject = JObject.Parse(json)
		
			Dim values = obj.DescendantsAndSelf().OfType(Of JProperty)().Where(Function(p) TypeOf p.Value Is JValue).GroupBy(Function(p) p.Name).ToList()
			Dim columns = values.[Select](Function(g) g.Key).ToArray()

			Dim parentsWithChildren = values.SelectMany(Function(g) g).SelectMany(Function(v) v.AncestorsAndSelf().OfType(Of JObject)().Skip(1)).ToHashSet()

			Dim rows = obj.DescendantsAndSelf() _
								.OfType(Of JObject)() _
								.Where(Function(o) o.PropertyValues().OfType(Of JValue)().Any()) _
								.Where(Function(o) o.Equals(obj) OrElse Not parentsWithChildren.Contains(o)) _
								.Select(Function(o) columns.Select(Function(c) _
																o.AncestorsAndSelf() _
																.OfType(Of JObject)() _
																.Select(Function(parent) parent(c)) _
																.OfType(Of JValue)() _
																.Select(Function(v) CStr(v)) _
																.FirstOrDefault()) _
															.Reverse() _
															.SkipWhile(Function(s) s Is Nothing) _
															.Reverse())

			Dim csvRows = DirectCast({columns}, IEnumerable(Of IEnumerable(Of String))).Concat(rows) _
							.Select(Function(r) String.Join(",", r))   ' HERE IS WHERE THE EXCEPTION OCCURS
			Dim csv = String.Join(vbLf, csvRows)		

																				
																				
			Console.WriteLine("Output CSV:")
			Console.WriteLine(csv)
			Console.WriteLine()

			Console.WriteLine("Input JSON:")
			Console.WriteLine(obj)
			Console.WriteLine()


			PrintType({ columns.AsEnumerable() })
			PrintType({ columns })

			PrintType(rows)
		End Sub	

		Function GetJson() as String
Dim Jstring As String = <![CDATA[
{
  "Response": [
    [
      {
        "id": 136662306,
        "symbol": "aaa",
        "status": "ACTIVE",
        "base": "731.07686321",
        "amount": "6.95345994",
        "timestamp": "1524781083.0",
        "swap": "0.0",
        "pl": "5127.4352653395923394"
      },
      {
        "id": 137733525,
        "symbol": "bbb",
        "status": "ACTIVE",
        "base": "636.75093128",
        "amount": "1.1",
        "timestamp": "1531902193.0",
        "swap": "0.0",
        "pl": "687.800226608"
      }
    ]
  ]
}
]]>.Value		
		Return Jstring		
		End Function
	
	End Module

	Public Module Module1	
		Public Sub Main()
		Console.WriteLine("Environment version: " & Environment.Version.ToString())
			Console.WriteLine("Json.NET version: " & GetType(JsonSerializer).Assembly.FullName)
            Console.WriteLine("")

			Try

				TestClass.Test()

			Catch ex as Exception

				Console.WriteLine("Unhandled exception: ")
				Console.WriteLine(ex)
				Throw

			End Try
			
		End Sub	
	End Module
;