DotConnect or "sqlite.phxsoftware.com" for using Entity Framework with SQLite
What's the best choice from dotConnect or " sqlite.phxsoftware.com " for using Entity Framework with SQLite (in C #)?
a source to share
My experience with DotConnect has been using DotConnect for Oracle for the past three months. I cannot separately comment on DotConnect for SQLLite, however I assume the quality will be similar.
I have not seen any difference between this vendor and the vendor supplied by Microsoft. The only exception was that when VS 2010 was released, it took Devart a couple of days to release an updated version of dotconnect. They promised that the new version will be available within a week and they will ship it in two days. They also emailed me a download link. They are responsive to emails and their forums are helpful. Hope this helps in making your decision.
a source to share
I have no experience with dotConnect, but I have successfully used System.Data.SQLite (sqlite.phxsoftware.com) over the past 3 years on several projects.
If there is a choice, I prefer open source components / libs, so if there are any problems I can fix them quickly myself without relying on vendor support and often wait while they prepare a new realease with a fix.
Check out the System.Data.SQLite SF page for some overviews.
a source to share