I assume you man the specific XmlDocument object as defined in
http://msdn.microsoft.com/en-us/library/system.xml.xmldocument%28v=vs.110%29.aspx[
^]
This object support LoadXml method and solution 2 hints that very briefly.
(Consider using XDocument instead.)
When you read an XML column in dot net, it becomes a XmlType
http://msdn.microsoft.com/en-us/library/system.data.sqltypes.sqlxml%28v=vs.110%29.aspx[
^]
This is ultimately an XmlReader object which you could manipulate like this:
static void Main(string[] args)
{
using (var mem = new MemoryStream())
{
/* Simulates your XmlType data field */
var writer = new StreamWriter(mem);
var xml = "=\=\<root><data>chicks</data></root>";
writer.Write(xml);
writer.Flush();
mem.Position = 0;
XmlReader rdr = XmlReader.Create(mem);
/*Example of manimuplating data*/
var xdoc = XDocument.Load(rdr);
IEnumerable<XElement> found = xdoc.Root.Elements("data");
Console.WriteLine("my data was: " + found.First().Value);
Console.ReadKey();
}
}