I am going to store data in an encrypted SQL Server CE 4 database, where the database is doing the encryption. (Note that SQL CE is the embedded version, not the fully installed server.)
When the data is decrypted does that only happen in memory or is it possible that is is logged or paged to disk in an unencrypted format?
The database will be accessed by an ASP.Net MVC application running in IIS.