序列化从sqlite返回的DataTable结果的C#正在返回XML格式

DataTable dt = new DataTable();
// 假设dt已经填充了数据

// 创建一个XmlWriterSettings对象来设置XML的格式
XmlWriterSettings settings = new XmlWriterSettings
{
    Indent = true, // 设置缩进，使XML更易读
    NewLineOnAttributes = true // 在属性之间插入换行
};

using (StringWriter stringWriter = new StringWriter())
using (XmlWriter xmlWriter = XmlWriter.Create(stringWriter, settings))
{
    dt.WriteXml(xmlWriter);
    string xmlString = stringWriter.ToString();
    Console.WriteLine(xmlString);
}

// 在序列化之前，对DataTable中的数据进行清理
foreach (DataRow row in dt.Rows)
{
    foreach (DataColumn column in dt.Columns)
    {
        row[column] = row[column].ToString().Replace("&", "&")
            .Replace("<", "&lt;")
            .Replace(">", "&gt;");
    }
}

// 然后进行序列化
dt.WriteXml("path_to_xml_file.xml");

// 分批次序列化数据
int batchSize = 1000;
int rowCount = dt.Rows.Count;
for (int i = 0; i < rowCount; i += batchSize)
{
    DataTable batchDt = dt.AsEnumerable().Skip(i).Take(batchSize).CopyToDataTable();
    batchDt.WriteXml("path_to_xml_file_" + i + ".xml");
}