Create a SQLite database based on an XSD Data Set
.net, database, sqlite
Solution
I suspect in the general case this is hard; XML Schema allows for some quite bizarre type constructions. I'm not sure how you would do substitution groups, or extensions to restrictions of types for example.
However it should be possible to knock something together quite quickly (especially mapping from the classes in System.Xml.Schema) that works for 90% of schemas (i.e. sequence and choice elements with a few simple data types).
Problem
Does anybody know if there is a way to create an SQLite database based on an XSD `DataSet`? In the past, I've just used a basic SQLite manager, but I want to fuse things a bit more with my `.NET` development if possible.