A bit of background: I'm a veteran Visual Foxpro programmer (don't laugh) with a fair knowledge of VB with a pet project on my hands. There's a program that I participated in writing a while back that originally processed its data in about four hours. Then we started receiving the data in XML format, and because of the way VFP does its XML processing, the program takes about six days to run. So I've been looking into how to get VB to work with XML data, thinking that it's got to improve on the situation.

I've picked up a copy of "Visual Basic 2008", by Stephens, but I'm still trying to wrap my brain around LINQ - yes, it seems a lot like SQL, but enough different that I'm not quite getting the results I'm expecting. So any hints on how to work with LINQ would be much appreciated - I can throw examples of what I've been trying on the board if that would help.

Thanks,

David

Hey,

You should look at LINQ to XML (http://msdn2.microsoft.com/en-us/library/bb308960.aspx); this is a big topic and I don't grasp it completely myself. However, LINQ isn't your only options. You can use the System.Xml namespace, which has an XmlDocument object that can load XML and you can use objects to query the file that way as well.

So you have a couple of options.

Brian