SqlLite is a very lightweight option for small-scale database projects. It uses single files for storage and uses direct code to access the data, instead of separate database drivers.
Being completely self-contained is a great plus for projects you want to deploy. No need to install SQL Server Express or other database drivers.
- Creating SqlLite databases
- Selecting SqlLite records
- Inserting SqlLite records
- Updating SqlLite records
- Deleting SqlLite records
- Primary keys and identity values
There is a free .Net driver package for SqlLite, making it very easy to add to your .Net projects.
Not all roses
On the down-side, it is not a full-featured implementation of SQL. Also, as it uses a single file it may be slower on some SQL operations.
Unlike other SQL engines, e.g. SQL Server Express, Visual Studio’s server explorer does not yet expose methods to create SqlLite tables. You will need a separate tool like the rather nice SQLite Database Browser. This will let you create databases, tables, indexes as well as test out your queries interactively.