Since Visual Studio 2010 is out , how about System.Data.SQLite for VS2010?
I have it working in VS2010 using EF4.
My blog post on the subject: http://nitoprograms.blogspot.com/2010/06/sqlite-and-entity-framework-4.html