membership profile and role provider for asp.net works with sqlite
You can download all files and example from here.
you may want to have a good manager for sqlite that manager lives here.