Nov 29, 2010 at 12:37 AM
Edited Nov 29, 2010 at 12:55 AM
I'm not sure how you could copy the table to a temp table, create the new one and fill the new table with the data from the old and then delete the temp table.
The table name is derived from the name of the class that defines the table structure. For example, on my WP7 device, the "Contacts" class "table" is stored in /Sterling/0/0/ directory. When I create a Contacts table and load 10 contacts
into it, then call Database.Truncate(typeof(Contact)), the following are deleted from Isolated Storage:
Then the directory itself (/Sterling/0/0) is deleted.
If you have two databases registered at the same time, the objects for the second database are stored in /Sterling/1.