Entity Framework MigrationSqlGenerator for SQLite

.net c# entity-framework migration sqlite

Question

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

1
11
4/8/2013 7:19:25 PM

Popular Answer

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).
http://entityframework.codeplex.com/

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.


http://entityframework.codeplex.com/
SqlCeMigrationSqlGenerator
Can we use EF migrations with MySql

7
5/23/2017 11:54:09 AM


Related Questions





Related

Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow