We currently have code like this:
Dim xDoc = XDocument.Load(myXMLFilePath)
The only way we know how to do it currently is by using a file path and impersonation (since this file is on a secured network path).
I've looked at XDocument.Load on MSDN, but I don't see anything.
I would suggest using a WebRequest to get a stream and load the stream into the document.
That very documentation says that the file parameter is "A URI string that references the file to load into a new XDocument." Furthermore, I have code that does exactly that---uses XDocument.Load with a URI.
//Sample XML
<Product>
<Name>Product1</Name>
<Price>0.00</Price>
</Product>
//Reading XML
XmlTextReader rdr = new XmlTextReader("http://your-url");
XDocument loaded = XDocument.Load(rdr);
//View the loaded contents
//Response.ClearHeaders();
//Response.ContentType = "text/xml;charset=UTF-8";
//Response.Write(loaded);
//Response.End();
var data = from c in loaded.Descendants("Product")
select new
{
name = c.Element("Name").Value,
price = c.Element("Price").Value,
};
foreach (var element in data)
{
//Do something here
}
