Is there a way to create a dataset from a sqlce database. Basically I want to iterate through the structure of a local database on the client computer and compare it with another sqlcedb (strongly typed so that is easy) to update any column or table changes.
Here is all I have so far. There are never any tables in the collection, so I beleive I need to "populate" the schema info from the database on the client machine, but I am not sure how to do it. Thanks.
Dim sConnectionString As String
sConnectionString = "Data Source=" & My.Settings.DBLocation
Dim objConn As New SqlCeConnection(sConnectionString)
Dim dsUserDB As New DataSet("UserDB")
Dim table As DataTable
For Each table In dsUserDB.tables