How to import data from xml to SQLite?

Question

SQLite

There is an application in C # that imports data from xml into ms sql 2008, while using an intermediate database ms sql compact. The problem is that at the moment the structure of the embedded database (sql compact) is created statically (when creating the database, the necessary empty tables are created) and if the xml file changes a little, you have to rewrite queries to create an intermediate database, I would like to automate this business.
I looked at SQLXML 4.0 from Microsoft, it works great with ms sql 2008, you specify xsd and xml and it creates a table and fills it with data, but it does not work with ms sql compact.
Now I'm looking towards SQLite, are there tools similar to SQLXML 4.0?

Answer 1

no