.NET application to edit SQLite database/file

Question

I'm designing an app in .NET which will enable me to click a button, and in turn, an SQLite file/database will be automatically edited (with a basic query). In order to do this do I need to implement a driver for SQLite, into my application, which will allow it to read the database file? Any help is appreciated, I'm a complete novice.

I've looked at the possibility of using ADO.NET and dbExpress thus far.

Answer 1

You don't need to implement the driver yourself, there are plenty of SQLite drivers for .NET out there already.

A couple of them

• SQLite ADO.NET provider
• Praeclarum's sqlite-net
• System.Data.SQLite

Answer 2

All you have to do is to download the SQLite ADO.Net provider from this site
Then you can follow the general guidelines for ADO.NET using the appropriate classes for SQLite

For more specific questions refer to the FAQ pages on the same site