Update to Compact

Ah, figured out my issue with "SELECT @@IDENTITY", that doesn't work with uniqueidentifier columns. For that, the best response will be probably to call a Guid.NewGUID in code, and insert that directly to the database, rather than let the database create the GUID itself.

There is talk though that Guid.NewGUID might not be the fastest option to use though.
http://www.peterfoot.net/NeedAGUIDInAHurry.aspx