Setting and changing SQLite database password in C#

Question

I'm implementing SQLite functionality in my code, where I can create an SQLite database file and communicate with it. I can't, however, password protect it. I've seen a lot of solutions, for example:

conn = new SQLiteConnection(connectionString);
conn.ChangePassword("Password");

However, the methods ChangePassword() or SetPassword() doesn't exist in System.Data.SQLite.SQLiteConnection, so it won't work. So my question is, am I missing something?

I'm using the latest release of the official SQLite Nuget Package.

Do you have a .net Core project? It's not there in .net Core, but it is there in .net Framework projects — NineBerry
– NineBerry, Commented Aug 15, 2019 at 10:23

NineBerry · Accepted Answer · 2019-08-15 10:36:59Z

4

The method is not supported in the .net Core (.net Standard) version of the library.

For connecting to a password-protected database, specify the password in the connection string. Use the SQLiteConnectionStringBuilder.Password or SQLiteConnectionStringBuilder.HexPassword properties.

For setting a password or changing the password, issue an sql pragma statement.

pragma key='NewPassword'

or

pragma rekey='NewPassword'

For details see Using the "key" PRAGMA

answered Aug 15, 2019 at 10:36

NineBerry

28.8k4 gold badges68 silver badges104 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Nocternity Over a year ago

Thanks, that was the issue! you're a life saver!

Collectives™ on Stack Overflow

Setting and changing SQLite database password in C#

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related