is there a MigrationSqlGenerator for SQLite to use with entity framework? I only found one from devart which is commercial.
No MigrationSqlGenerator found for provider 'System.Data.SQLite'. Use the SetSqlGenerator method in the target migrations configuration class to register additional SQL generators.
This is what I do: http://msdn.microsoft.com/en-gb/data/jj591621
I don't think there is any, free one, to my knowledge.
If you don't care for the Devart commercial
dotConnect for SQLite - you could try implementing one yourself - it may not be as simple but you have the EF source code at your disposal (for EF6 but those parts are quite similar I'd say).
If you take a look at the SqlCeMigrationSqlGenerator source code (the other source, I couldn't find one on offical site, but you can download and check)
...you'll see that the generator is relatively simplistic. Of course that goes for Ce which is using standard Sql client as underlying generator.
SQLite will require more work but may not be that hard.
Also, similar thing coming from a well know source on EF here - Can we use EF migrations with MySql
And don't 'yell at me' :) I know this isn't what you're looking for - but I think that's the only alternative really.