Which is the better choice out of dotConnect or "sqlite.phxsoftware.com" for using Entity Framework with SQLite (in C#)?
Asked
Active
Viewed 2,001 times
2
John Saunders
- 160,644
- 26
- 247
- 397
Greg
- 34,042
- 79
- 253
- 454
-
arrr...I see with dotConnect the version that supports EF costs $$$ – Greg Apr 29 '10 at 02:33
3 Answers
3
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.
Dean
- 3,336
- 6
- 36
- 37
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
Sky Sanders
- 36,396
- 8
- 69
- 90
-
it seems like it supports the Database => Entity generation flow, but not the Entity => create database schema for a Sqlite database - is this your experience code poet? – Greg May 04 '10 at 10:50
-
@Greg - yes, the current version was developed before vs10, so model first is not an option. – Sky Sanders May 04 '10 at 11:15
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.
Nick Martyshchenko
- 4,231
- 2
- 20
- 24
-
thanks - I'll think I go with you - not sure to do with the question - guess I should lead it open as noone has really answered it in it's current form yet – Greg Apr 29 '10 at 21:06