Where I can find example of SQLite database file or dump of it?

There is a nice sample database called Chinook. It's trying to be the modern example to replace NorthWind. They have versions for different database servers including SQLite.

• Homepage, DB diagram, etc.. http://chinookdatabase.codeplex.com/
• Github (seems more updated than CodePlex) https://github.com/lerocha/chinook-database
• Latest SQLite download to date of post: https://chinookdatabase.codeplex.com/releases/view/55681#fileDownload6
• Download SQLite Sample Database to get the Chinook database file directly http://www.sqlitetutorial.net/sqlite-sample-database/
• More SQLite related projects and samples on CodePlex http://www.codeplex.com/site/search?query=sqlite&ac=8

Also, check this sample in the SQLite .NET client forums (attached to first post)

• Getting the Microsoft EFQuerySamples project to work with SQLite

Maybe a GUI tool to create database stuff will make starting easier, check this one, free for personal use

• http://www.sqliteexpert.com/

Personally, I create SQLite databases for testing NHibernate mappings. Usually I create my classes and mappings then use the mappings to generate schema to a new SQLite file (or in memory database, more often) and use that. Most NHibernate introduction articles do that as well.

SQLite is whidely used by many applications so I am pretty sure very lot examples can be found on your computer. For example, on my Win10 PC if I search in "c:\Users\Konstantin" (my profile) for files with:

• file name mask: *.sqlite;*.db
• text inside: SQLite format 3

I am currently getting 785 results. Most of them, which have that text in the beginning - it is 99% SQLite database files. Particularly I see that it is used by skype, viber, dropbox, office and firefox.