Download SQLite Providers
membership, profile, role, personalization provider for asp.net works with sqlite
V2 with personalization(webpart) provider here.
V1-You can download all files and example from here.
you may want to have a good manager for sqlite that manager lives here.
SQLite ASP.NET membership profile and role providers