System.Data.SQLite

Hi having some issues getting sqlite working with .net 4 entity framework. I have this in my app.config: I have: System.Data System.Data.Entity System.Data.Linq System.Data.SQLite System.Data.SQLite.Linq However every time I run the tests I'm getting: System.InvalidCastException: Unable to cast object of type 'System.Data.SQLite.SQLiteConnection' to type 'System.Data.SqlClient.SqlConnection'. Any ideas?

I had the same issue and found the solution was to change the edmx file directly. At the beginning of the file change the provider to SQLite like this; .... <!-- SSDL content --> <edmx:StorageModels> <Schema Namespace="MyModel.Store" Alias="Self" Provider="System.Data.Sqlite" .... ..... If the field types are compatible then all will work fine. At least it did for me.