using System;

using System.IO;

using System.Text;

using System.Linq;

using System.Data;

using System.Data.DataSetExtensions;

using System.Collections.Generic;

using System.Xml;

using Newtonsoft.Json;

public class Program

{

    public static void Main()

    {

        DataSet dsSet = new DataSet("OrderManagement");

        DataTable tCustumer = new DataTable("Custumer");

        DataTable tOrder = new DataTable("Order");

​

        tCustumer.Columns.Add("CustumerId");

        tCustumer.Columns.Add("Name");

        tOrder.Columns.Add("OrderId");

        tOrder.Columns.Add("CustumerId");

        tOrder.Columns.Add("Article");

​

        tCustumer.Rows.Add("1", "Chris");

        tCustumer.Rows.Add("2", "Ronja");

        tCustumer.Rows.Add("3", "Thomas");

​

        tOrder.Rows.Add("1", "1", "chocolate");

        tOrder.Rows.Add("2", "1", "apples");

        tOrder.Rows.Add("3", "2", "dogfood");

        tOrder.Rows.Add("4", "3", "keyboard");

        tOrder.Rows.Add("4", "3", "tomatos");

        tOrder.Rows.Add("4", "3", "green tea");

​

        dsSet.Tables.Add(tCustumer);

        dsSet.Tables.Add(tOrder);

​

        //dsSet.Relations.Add(

        //    "RelationCustumerOrder",

        //    dsSet.Tables["Custumer"].Columns["CustumerId"],

        //    dsSet.Tables["Order"].Columns["CustumerId"], false

        //    );

​

        dsSet.Relations.Add(

            "RelationCustumerOrder",

            dsSet.Tables["Custumer"].Columns["CustumerId"],

            dsSet.Tables["Order"].Columns["CustumerId"]

        );

        dsSet.Relations[0].Nested = true;   

        dsSet.AcceptChanges();

​

        //JsonSerializerSettings settings = new JsonSerializerSettings();

        //settings.TypeNameHandling = TypeNameHandling.All;

        //string jsonResult = JsonConvert.SerializeObject(dsSet, Newtonsoft.Json.Formatting.Indented, settings);

        //Console.WriteLine(jsonResult);

​

        StringWriter sw = new StringWriter();

        dsSet.WriteXml(sw);

        string xmlString = sw.ToString();

        XmlDocument doc = new XmlDocument();

        doc.LoadXml(xmlString);

        JsonSerializerSettings settings = new JsonSerializerSettings();

        settings.TypeNameHandling = TypeNameHandling.All;

        string jsonResult = JsonConvert.SerializeXmlNode(doc, Newtonsoft.Json.Formatting.Indented);

        Console.WriteLine(jsonResult);

    }

}