After a few requests, I decided to go back and do another data provider for BlogEngine.NET. This time around I’m using SQLite. SQLite is a file based format very similar to VistaDB Express and it has no restrictions . It is another fine option for blog data and very easy to work with.
Once again, this is a complete provider setup. It will store all your blog
posts, pages, profiles, users, roles, and settings. It could be partially
implemented by making changes to the default providers in your web.config if you
desire.
The process for getting setup is very easy. The instructions are assuming you have BlogEngine.NET setup already. If you don’t please check out the initial setup screen cast to walk you through the process. If you already have an existing blog, be sure to backup before following these steps.
1. Download the SQLite database provider for BlogEngine and unzip it.
2. Download the SQLite ADO.NET Provider binaries.
3. In your SQLite ADO.NET download, find the System.Data.SQLite.DLL and add it to your blog’s bin folder.
4. From the BlogEngine download, copy the BlogEngine.s3db file to your blog’s App_Data folder.
5. Next, replace your blog’s web.config file with the new web.config file from the BlogEngine download.
6. Browse out to your blog and you should see the BlogEngine with SQLite welcome post.
7. Your User security has been reset, so login as Admin (with the password, admin), add new users, and change your password.
That is it. You should be now blogging with data stored in SQLite.