I'm making Windows Phone 8.1 something similar to a dictionary where there will be a lot of text with sorting, searching, sorting by name.
In which situations does each fit better or is it more appropriate?
SQL Server Compact you can enjoy benefits that perhaps Isolated Storage can not provide you with, such as using PLinq (Parallel Linq, see: link )
I confess, I did not get to test PLinq in App for Windows Phone, but compared to desktop performance really better when used correctly. Another point, the SQL server was made for this, store large masses of data, while the Isolated Storage, serves to save data for quick access such as configurations. However, what I think will really be the key point, it will not be where you will save the data but how you will handle it and at this point, I believe that SQL again draws attention to parallelism support. / p>
