c#datatable序列化xml

    public static List<T> ToListModel<T>(this DataTable dt)
    {
        if (dt.Rows.Count <= 0) return null;
        string typeName = typeof(T).Name;
        using (MemoryStream ms = new MemoryStream())
        {
            dt.WriteXml(ms);
            ms.Position = 0;
            using (StreamReader sr = new StreamReader(ms))
            {
                string title = "<?xml version="1.0" encoding="utf - 8"?>";
                string s = title + sr.ReadToEnd();
                s = s.Replace("<NewDataSet>", $"<ArrayOf{typeName} xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">")
                    .Replace("</NewDataSet>", $"</ArrayOf{typeName}>")
                    .Replace("<ds>", $"<{typeName}>").Replace("</ds>", $"</{typeName}>");
                return Common.XML.DeXMLSerialize<List<T>>(s);
            }
        }
    }

            public static T DeXMLSerialize<T>(string xmlString)
            {
                T cloneObject = default(T);

                StringBuilder buffer = new StringBuilder();
                buffer.Append(xmlString);

                XmlSerializer serializer = new XmlSerializer(typeof(T));

                using (TextReader reader = new StringReader(buffer.ToString()))
                {
                    Object obj = serializer.Deserialize(reader);
                    cloneObject = (T)obj;
                }

                return cloneObject;
            }

使用方法:

  var list = new DataTable().ToListModel<List<MyClass>>();

 MyClass:

public class MyClass {
    [XmlElement("sql_column_name")]
    public int MyProperty { get; set; }
}