I read an article on 'visualbasic.about.com' (can't remember th exact URL) but it explained the use of XML as a database for applications. Now I currently have a working application that is using SQL Server 2005 Express as its db. For reasons such as users having to install the DBMS on the machines, the large setup file for deploying with SQL Server as a prerequisite, and mor on the lines that my database has only 2 small tables with one foreign key relation between them, and the data should not contain more than 50 rows in Table1 and 15 in Table2.
Would I be able to work with XML as a file-type database in this regard, or would u deem it not feasible taking into account the above-mentioned
If this is feasible as a more "light-weight" solution, how should I go about my business Can I create a dataset representation of my tables in the Dataset Designer and then persist that to an XML file
Please could someone shed some light on this for me, or direct me to a step-by-step article or video
Thank you and kind regards!
shalan