I came across an issue a while back with SQLite and the Entity Framework.
EF creates complex type classes and SQLite does not support any sort of complex type.
I thought I could work around this, but it becomes tedious having to remove the foreign key constraints in my edmx designer view on every EF build.
I really need the complex classes because the same Model is being used in my WebApp. I want to keep the WebApp and the mobile on the same Model (seems a fair expectation).
Anybody come across the same situation?
I came across http://www.devart.com/dotconnect/sqlite/ dotConnect for SQLite but don't want to fork out 150 bucks and waste more time.