gistfile1.cs

  using(var cn = new SqlConnection(MA_CONNECSHUNS))
            using (var cmd = new SqlCommand(MA_QUERIES, cn))
            {
                cn.Open();

                using (var reader = cmd.ExecuteReader())
                while (reader.Read())
                {
                    SqlXml xml = reader.GetSqlXml(1);
                    using (var xr = xml.CreateReader())
                    {
                       var root = XDocument.Load(xr);
                        var foo = GetDynamic(root);
                        string json = Newtonsoft.Json.JsonConvert.SerializeObject(foo);
                        Console.WriteLine(json);
                    }
                }
            }