Hello,
I'm porting some ADO code written in VB to VB.NET/ADO.NET.
In the new version want to work offline using an XML file. This is simple with an ADO.NET DataSet. With one exception:
the old code was written with SQL statements for select/insert/update/delete. With a DataSet you can only use the sql queries with a DataConnector, connected to a valid database.
Q: has anybody implemented a DataConnector/Managed Provider for a plain old XML file?
I don't want to have to port all the code from SQL statements to looping through a DataSet's DataTables/DataRows and manually updating stuff if I can avoid it.
If there's no DataConnector for an XML file, is there are way to execute queries (select/insert/update/delete) against a DataSet without a DataConnector?
In other words, I want the equivalent of ADO's "ExecSQLDirect" function for a DataSet.
Thanks in advance!
I'm porting some ADO code written in VB to VB.NET/ADO.NET.
In the new version want to work offline using an XML file. This is simple with an ADO.NET DataSet. With one exception:
the old code was written with SQL statements for select/insert/update/delete. With a DataSet you can only use the sql queries with a DataConnector, connected to a valid database.
Q: has anybody implemented a DataConnector/Managed Provider for a plain old XML file?
I don't want to have to port all the code from SQL statements to looping through a DataSet's DataTables/DataRows and manually updating stuff if I can avoid it.
If there's no DataConnector for an XML file, is there are way to execute queries (select/insert/update/delete) against a DataSet without a DataConnector?
In other words, I want the equivalent of ADO's "ExecSQLDirect" function for a DataSet.
Thanks in advance!