DataSet to XDocument Conversion and back

Question

I am working on an application where I need to convert a DataSet into XDOcument in the Middle Tier ( XDOcument is much lighter to transport than XmlDocument) and then covert the XDocument back into DataSet at the Front end.

I am not able to figure out an efficient way of doing this. As of now I am converting the DataSet to XMlDocumenmt and then to XDocument and viceversa. Is there a better way?

Thanks.

Answer 1

DataSets are serializable. That would probably be easier to transport than XDocument.

string xmlString;

System.Xml.Serialization.XmlSerializer oSerializer = new System.Xml.Serialization.XmlSerializer(typeof(DataSet));

DataSet ds = new DataSet();
StringBuilder sb = new StringBuilder();

//One side
using (StringWriter sw = new StringWriter(sb))
{
    oSerializer.Serialize(sw, ds);
    xmlString = sb.ToString();
}

//Other side
using (StringReader sr = new StringReader(xmlString))
{
    ds = (DataSet)oSerializer.Deserialize(sr);
}