I'm a newbie to ADO.NET database programming.
1. I have used the VS Designer to create a DataSet-derived class with tables, columns, relations and constraints. All very nice with tons of generated code for all kinds of useful activity.
2. I also have a zero-byte DB file created with the static Connection.CreateFile method.
My question is this: how does one inject the schema from the DataSet into the empty DB file????? I perhaps could re-create the schema using a boatload of Create commands to create the individual tables, relations, etc, but is that really the ONLY way to migrate the schema from a VS Designer-created DataSet to an empty DataSource?
Would I be better off keeping an empty (data-less) instance of the DB file around and copying it to a new file so that I can do a Connection.Open on the copy? It sounds like that would work, but seems a bit of a hack.