Losing data

I am having a problem with the database used in MyMovieCollection losing all its data if you do anything with it in design view. 

Open the app
Add a record
Close the app. 
Reopen the app.

The data is there

Exit entirely out of VB.Net
Reopen VB.Net
Reopen the MyMovieCollection App
The data is there.

Open the database explorer
Expand the tables
Expand the DVD table  OR (the way I found the bug)
Right click the DVD table and Show Table Data

There is no data.
Run the app
The data is gone.

This appears to be a "feature" of VB.Net or the SQL data connection, not the movie collection app specifically.  I have done the same thing with a connection to an Access database (in an app I am building) and am not losing the data

This is fascinating though.  I went in to "show table data", and added a record manually, actually I added ONLY ID through Actors.  One record, just "test" or 1 in all the fields I populated.  I then performed the same test above and the data is NOT deleted!

I closed, exited, came back in, expanded the table to view the field, "viewed table data" etc, my manually entered record is there.

I then opened the app.
Went to the net and selected a movie and added it to the database.
Closed the app
Closed VB
Reopened VB and the app.
The movie I had just added is still there as is my "test" record.

Opened Database Explorer
Expanded tables
Right clicked DVDs Show table data

ONLY my test record is still there.  The movie record is gone, but my test record remains.

Hmmm.....

Can anyone verify my results.  Has anyone found a solution / workaround