For those users like myself that want to check out the internals of the new database here are some useful resource links...
The main bits you need are the Database viewer and MS runtime (for x64 install both the 32 and 64 bit runtimes).
Wiki: http://en.wikipedia.org/wiki/SQL_Server_Compact
Database Viewer: http://sourceforge.net/p/compactview/home/Home/
Info+Resources: http://erikej.blogspot.com/
MS runtime: http://www.microsoft.com/download/en/details.aspx?id=5783
The main bits you need are the Database viewer and MS runtime (for x64 install both the 32 and 64 bit runtimes).
Wiki: http://en.wikipedia.org/wiki/SQL_Server_Compact
Database Viewer: http://sourceforge.net/p/compactview/home/Home/
Info+Resources: http://erikej.blogspot.com/
MS runtime: http://www.microsoft.com/download/en/details.aspx?id=5783