Link to Microsoft.Data.Sqlite docs from EF docs where appropriate

[habib-developer]

Actually, I'm using Entity Framework core 1.0 with my WinForms application and using Sqlite3. I've to ask that is there any way to encrypt SQLite DB and use with EF Core 1.0?

[ajcvickers]

@bricelam to respond.

[bricelam]

No easy way in EF Core 1.0, but these docs cover using encryption with Microsoft.Data.Sqlite 3.1. Here's the gist of it:

dotnet remove package Microsoft.EntityFrameworkCore.Sqlite
dotnet add package Microsoft.EntityFrameworkCore.Sqlite.Core
dotnet add package SQLitePCLRaw.bundle_e_sqlcipher

options.UseSqlite("Data Source=my.db;Password=myKey");

[ajcvickers]

See also #2056 for linking the in-memory mode.