Clever Geek Handbook

Data access approach for using sqlite in a C # VS2008 project?

I have Sqlite working in a basic sense for my C # project in Visual Studio 2008 using the ADO.net Sqlite wrapper from http://sqlite.phxsoftware.com/ .

Question. For C # winforms newbies, which VS2008 data access layer approach would you recommend I am using for my winforms application, since I need to write / read data from sqlite database?

+2


source to share


3 answers


I found that http://sqlite.phxsoftware.com/ works fine with Entity Framework. VS2010 doesn't seem to generate the correct SQL for the "create DB from model" approach, however the "create Model from DB" approach works fine.



+1


source


How about using an ORM like Subsonic? SubsonicProject.com



+1


source


Maybe you should take a look at this lightweight SQLite wrapper which has reflection-based ORM functionality and some easy-to-use Linq support: http://code.google.com/p/sqlite-net/

It links directly to the released SQLite library and has no other dependencies.

0


source






More articles:


All Articles