I have a 150 MB XML file which is used as DB in my project. Currently I'm using XmlReader to read content from it. I want to know if it is better to use XmlReader or LINQ to XML for this scenario.
Note that I'm searching for an item in this XML and display search result, so it can take a long time or just a moment.
If you want performance use XMLReader. It doesn't read the whole file and build the DOM tree in memory. It instead, reads the file from disk and gives you back each node it finds on the way.
With a quick google search I found a performance comparison of XmlReader, LINQ to XML and XmlDocument.Load.