Hi all,

we have an xml file.
Based on this file we have to generate menu. This xml file changes
every day.
We are loading the xml file into the application memory and
transforming the data of xml file into collections (using classes).


1.  Pumping the whole xml data into collections is the correct way or
not?
2.  As xml is already a structured representation of data, is it
necessary to convert the data into collections?
3.  If we converted the data into collections, is it true we can get
better performance rather than querying the xml everytime?
4.  Querying the xml everytime consumes more time rather than using
collections.  Is it true?
5.  Xml file size is small approximately 100KB.
6.  Can serializer is useful for me at all?

Getting Currency Manager takes a long time
AcceptChanges() is very slow
Connection String Problem
Change Connection String at runtime.
CLR Trigger Rollback