Write Dataset to XML with WriteSchema

Serializing dataset ignores empty datatables

When you call lDataSet.WriteXml(aXMLFilePath), any data table without rows will be ignored. To include it (because table schema may still be important), use the WriteXml overload that writes to an xmlWriter and enable"WriteSchema".

I use XDocument that can create XmlWriter but I'm sure there are other ways.

XDocument lXDocument = new XDocument();

using (XmlWriter lXmlWriter = lXDocument.CreateWriter())

{

lMasterDataSet.WriteXml(lXmlWriter, XmlWriteMode.WriteSchema);

}

lXDocument.Save(@"c:\temp\PSReportServer_MasterDataSetWithSchema.xml");