ASP.Net: Generate nested JSON from SQL Server Database using C# and VB.Net

Hi Mr.Muddassar

I have an issue in nested Json from MSSQL table. I am using normal Json (not nested). It works fine. But nested, I could not do.

Pls Advise me

thank you Maideen

{    
    "Shipment":  [
        {
            "ShipmentServiceType": "Standard Delivery",
            "SenderName": "ABC",
            "RecipientName": "XYZ",        
            
			"ShipmentAddressFrom":  {
                "CompanyName": "ABC ENTERPRISE",
                "UnitNumber": "6, ",
                "Address": "Jalan TP2, "
 
            },
            "ShipmentAddressTo":   {
                "CompanyName": "XYZ Enterprise",
                "UnitNumber": "10, ",
                "Address": "Jalan TP5, "
            },

	     "InsurancePurchase" : [
			  {
				  "ProductDescription":"The description of the item .",
				  "Quantity":	1,		
				  "UnitPrice":	 110	
			   }],
		 "WayBill": [
                {
                    "WayBillNo": ""
                },
            ],
            "DONumber": ""
        }     
    ]
}