You specified a password in the connection string, but the native SQLite library you're using doesn't support encryption

Question

I am facing an issue to set the Password attribute in the Sqlite connection string in Xamarin Forms Android application. It is working fine in Xamarin Forms iOS. I have used the following `

connection.ConnectionString = new SqliteConnectionStringBuilder(connection.ConnectionString)
        { Password = password }
        .ToString();
connection.Open();

` enter image description here You specified a password in the connection string, but the native SQLite library you're using doesn't support encryption.

I am using Microsoft.Data.Sqlite 3.1.5 nuget package on my Xamarin Forms application.

Any help would be appreciated.

Microsoft.Data.Sqlite does not support encryption. https://learn.microsoft.com/en-us/dotnet/standard/data/sqlite/encryption?tabs=netcore-cli — Jason, Jun 26 '20 at 13:07
@Jason Please have a look https://www.bricelam.net/2016/06/13/sqlite-encryption.html — Achayan, Jun 26 '20 at 16:17
The error message is clear that it does not support encryption. — nevermore, Jun 29 '20 at 09:35

score 5 · Answer 1 · answered Nov 24 '20 at 16:55

I know that is later to respond to this question, but the answer can help others to get solution quickly.

Below the solution as Jason has comment above :

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

https://learn.microsoft.com/en-us/dotnet/standard/data/sqlite/encryption?tabs=netcore-cli

You specified a password in the connection string, but the native SQLite library you're using doesn't support encryption

1 Answers1