I've really been enjoying SQLite lately. When using a host like Discount ASP, you are required to pay for SQL Server, but you can use an SQLite database without incurring the extra charge. But what happens when you want to use the membership, role, and profile providers in your ASP.NET application and avoid paying for the database service?
Check this out. This project is quite easy to snap into your own application, and gives you the required edits to make to your web.config file in order to use the providers for roles, memberships, and profiles. I have been using this project in a solution since February and have been incredibly impressed with it, and wanted to share it in the event that someone else could benefit as I have.