System.Data.SQLite

 Hi,

What are the current reliable data access approaches that are available in VS2008 using this ADO.net sqlite integration for a small project with only a handful of tables?  For example:

* base sqlite classes
* Dataset / DataAdapter
* LINQ (supported?, robust?)
* Entity Framework  (supported?, robust?)
* other?

In other words, what are people using with sqlite & "System.Data.SQLite" in production out of the above?  As a new C#/.Net person I guess I'm after the easiest/simplest way to work with my sqlite database, but would like not to have to craft SQL code myself each time I need to access it...

Thanks

PS.

Re Linq To SQL - Whilst I can do a "Add Item, LINQ to SQL" and get a .dbml class and design panel, when I drag one of the sqlite database tables from the Service Explorer across onto the design surface I get an error message "the select object uses an unsupported database provided".  Is LINQ to SQL fully operational / supported yet?

Re Entity Framework - When I go "Add Item / Data Item " - I don't see an Entity Framework option.  There is a LINQ to SQL option but not an Entity Framework option.  Is Entity Framework an operational / support thing yet?