Leave in SQL Server only users, authentication and sessions data.
All other user-specific data should be located in standalone (i.e. "personal") SQL CE 4.0 databases per user.
Database name should be GUID.
Store them in the following folders pattern (based on creation date):
Original comment by sevenate (Bitbucket: sevenate, GitHub: sevenate).
Closed #3: Migrate to SQL CE 4.0;
Closed #10: Include SQL scripts to deployment;
Closed #15: Store password hash in database;
Closed #22: Remove "Database.mdf" from unit tests;
Updated: xUnit to 1.8;
sevenate
commented
12 years ago
Original report by sevenate (Bitbucket: sevenate, GitHub: sevenate).
Leave in SQL Server only users, authentication and sessions data. All other user-specific data should be located in standalone (i.e. "personal") SQL CE 4.0 databases per user.
Database name should be GUID.
Store them in the following folders pattern (based on creation date):
**APP_DATA\yyyy\mm\dd\GUID.data**
See also [[http://erikej.blogspot.com/2011/01/comparison-of-sql-server-compact-4-and.html|comparison with SQL Express]].