先用Linq查询XML节点,再转换成List或Model,再用Json.NET转为Json
好处是可以随时返回List
XML
EricSun 123456 Hello I'm from Dalian Ray 654321 Hello I'm from Jilin
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) { Listlist = new List (); List list2 = new List (); 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; } }}