title: Does PRAGMA Key='SomeKey' in SQlite encrypt/decrypt whole data of database?
body: <p>We are developing Xamarin.forms application and we have to encrypt our database.
  While googling I found something is 'PRAGMA key'. When I started using this in my code then on opening the db file via any browser I get a dialog box to enter the Passphrase.</p>
  
  <p>My question here is, does 'PRAGMA key' encrypt whole database or it just works like a password to open the database file.</p>
  
  <p>Any help is greatly appreciated.</p>