Dunno if this is the right place for this as the only compact sql subject I could find was for mobile development and I'm using this in a desktop app...
Anyway, I've seen tons of examples of creating datasets in code but never have I seen this used to create an on disk database file. I've already done up database creation, table creation, and the lot using sql but the dataset method just seems so much cleaner and less labour to do. It just doesn't seem logical to me that you could completely create a schema with dataset and yet not dump that to disk as an actual database. Probably I'm just searching on the wrong terms in google...
A pointer to an example program would be great too!
VB 2010 Express and compact framework.
Anyway, I've seen tons of examples of creating datasets in code but never have I seen this used to create an on disk database file. I've already done up database creation, table creation, and the lot using sql but the dataset method just seems so much cleaner and less labour to do. It just doesn't seem logical to me that you could completely create a schema with dataset and yet not dump that to disk as an actual database. Probably I'm just searching on the wrong terms in google...
A pointer to an example program would be great too!
VB 2010 Express and compact framework.