asp.net XML轉JSON

先用Linq查詢XML節點，再轉換成List或Model，再用Json.NET轉為Json

好處是可以隨時返回List

XML

<?xml version="1.0" encoding="utf-8" ?>    <Users>        <User ID="111111">        <name>EricSun</name>        <password>123456</password>        <description>Hello I'm from Dalian</description>    </User>    <User ID="222222">        <name>Ray</name>        <password>654321</password>        <description>Hello I'm from Jilin</description>        </User>    </Users>

C#代碼

using System;using System.Collections.Generic;using System.Linq;using System.Xml.Linq;using Newtonsoft.Json;namespace ConsoleApplication1{    class Program    {        static void Main(string[] args)        {            List<User> list = new List<User>();            List<User> list2 = new List<User>();            XElement rootNode = XElement.Load(@"D:\234.xml");            //第一種查詢            var mynode = (from r in rootNode.Descendants("User")                          select r).ToList();            foreach (var item in mynode)            {                User model = new User();                model.name = item.Element("name").Value;                model.password = item.Element("password").Value;                model.description = item.Element("description").Value;                list.Add(model);            }            //第一種查詢結束            //轉換為JSON            string json = JsonConvert.SerializeObject(list);            //第二種查詢            var mynode2 = from r2 in rootNode.Descendants("User")                          select new                              {                                  Name = r2.Element("name").Value,                                  Password = r2.Element("password").Value,                                  Description = r2.Element("description").Value                              };            foreach (var item in mynode2)            {                User model = new User();                model.name = item.Name;                model.password = item.Password;                model.description = item.Description;                list2.Add(model);            }           //第二種查詢結束            //轉換為JSON            string json2 = JsonConvert.SerializeObject(list2);            Console.ReadKey();        }    }    public class User    {        public string name { get; set; }        public string password { get; set; }        public string description { get; set; }    }}