dotConnect or "sqlite.phxsoftware.com" for using Entity Framework with SQLite

Question

Which is the better choice out of dotConnect or "sqlite.phxsoftware.com" for using Entity Framework with SQLite (in C#)?

Answer 1

I don't have any experience with dotConnect but successfully using System.Data.SQLite (sqlite.phxsoftware.com) during past 3 years in several projects.

If there are choice I prefer open source components/libs so if there are any trouble I can fast troubleshoot it myself without rely on vendor's support and often waiting while they prepare new realease with bugfix.

Check System.Data.SQLite SF page for some reviews.

Answer 2

My experience with DotConnect is using DotConnect for Oracle over the past three months. I cannot comment specifically on DotConnect for SQLLite, however I assume the quality would be similar.

I have not seen any difference between this provider and the provider supplied by Microsoft. The one exception was when VS 2010 was released, it took Devart a couple of days to release an updated version of dotconnect. They had promised the new version would be availble within a week and they delivered it in two days. They also emailed me with a download link. They are responsive to emails and their forums are helpful. Hope this helps in making your decision.

Answer 3

System.Data.SQLite works quite well with EF.

I speak from a lot of experience with this scenario.

System.Data.SQLite is and will always be free, whereas dotconnect is bait and switch on features.

HTH