After my success using SQLite with NHibernate, I am very happy to use it for testing with Entity Framework Code First.
If you have some example connections string and set up demos, that would be great and save a bit of time from my hectic day.
Thanks a lot.
EDIT:
Worth mentioning that I am getting this error during debugging when applying crud actions via the EF "data context":
Unable to determine the provider name for connection of type 'System.Data.SQLite.SQLiteConnection'.
<system.data>
<DbProviderFactories>
<remove invariant="System.Data.SQLite"/>
<add name="SQLite Data Provider" invariant="System.Data.SQLite" description=".Net Framework Data Provider for SQLite"
type="System.Data.SQLite.SQLiteFactory, System.Data.SQLite" />
</DbProviderFactories>
</system.data>
<connectionStrings>
<add name="DataContext"
connectionString="Data Source=:memory:;Version=3;New=True;"
providerName="System.Data.SQLite"
/>
</connectionStrings>
Hopefully EF does integrate with SQLite in this fashion. Although the error message, alarmingly, suggests probably not.