tags:

views:

49

answers:

1

Hi,

What would people recommend using as a persistence approach for Sqlite from a C# windows forms application - LINQ-to-SQL or Entity Framework?

(I ask this on the basis that I've had some people say stay away from DataTables and move to one of the new approaches)

+4  A: 

LINQ-to-SQL is only available for SQL Server. That may limit your choices somewhat.

Apparently there's a project called DbLinq that tries to port the LINQ-to-SQL interfaces to other databases: http://code.google.com/p/dblinq2007/ . Haven't tried it myself.

roufamatic
I saw the following suggested on another link http://www.devart.com/linqconnect/ also... I'm not sure however how solid either of these two are, any ideas?
Greg
Wish I knew. The fact they exist shows just how much resistance there is to EF though! My next project will be Fluent NHibernate (http://fluentnhibernate.org/)
roufamatic
just briefly - what's the main thrust of this resistance to EF (being somewhat new to .NET)
Greg
roufamatic