XML and SQL
-
Is there a way to query an XML file via SQL in C#? For example, is it possible to use ado recordsets? What I want to do is use an XML file as db and list, add new, update, delete records... Thanks in advance. Radgar "Imagination is more important than knowledge." - Albert Einstein
-
Is there a way to query an XML file via SQL in C#? For example, is it possible to use ado recordsets? What I want to do is use an XML file as db and list, add new, update, delete records... Thanks in advance. Radgar "Imagination is more important than knowledge." - Albert Einstein
-
I started the code using DOM but the XML database may include more than 1000 records and I want to avoid "for" loops while deleting, updating or adding multiple records. I think doing these with a recordset can be much more faster, easier and stronger. Please, correct me if I'm wrong.
-
Is there a way to query an XML file via SQL in C#? For example, is it possible to use ado recordsets? What I want to do is use an XML file as db and list, add new, update, delete records... Thanks in advance. Radgar "Imagination is more important than knowledge." - Albert Einstein
Load the XML in a DataSet with ReadXml. You won't have SQL support, but it will be fairly close to it. Yes, even I am blogging now!