tags:

views:

273

answers:

1
+1  Q: 

sqlite ado.net provider - which is the most popular to use? (e.g. phxsoftware, devart, mindscape)

Hi,

Regarding starting to use SQLite within C# Visual Studio 2008 for a winforms application, it seems from the sqlite site you have to download a sqlite ado.net provider, and there are numerous listed (in .net section of sqlite wrappers)

QUESTION - Which is the most popular/robust sqlite wrapper that people are using? Some from the list seem to include:

I'm not sure yet whether I should want or need support for LINQ or EntityFramework. Most fundamental requirement is just one that allows me to work with a few tables worth of data from the sqlite database within VS2008 easily.

Thanks

+1  A: 

I have been using phxsoftware alot with C# applications. I works very fast, even with large (ten of thousands) tables. It is also .NET 2 compliant, if that is an issue.

As to the free issue, this package is free.

Am  2009-10-11 00:31:35
Am - are you using LINQ or EntityFramework, or just sticking to using the System.Data.SQLite classes? I'm wondering for my simple few tables whether it's worth trying to wrap my head around using LINQ or EntityFramework (if it's possible with the wrapper)
Greg  2009-10-11 00:38:14
I`m using the the SQLite classes. They are standard to the C# data classes, and have all the standard DataProvider, Parameter, etc.
Am  2009-10-11 00:48:33

related questions

Displaying Flash content in a C# WinForms application
How to get the value of built, encoded ViewState?
Unhandled Exception Handler in .NET 1.1
How do I connect to a database and loop over a recordset in C#?
How do I most elegantly express left join with aggregate SQL as LINQ query
Get a new object instance from a Type in C#
.NET Testing Framework Advice
Automatically update version number
What is the difference between an int and an Integer in Java/C#?
How to write to Web.Config in Medium Trust ?
WinForms ComboBox data binding gotcha
How do you sort a C# dictionary by value?
Adding Scripting functionality to .NET applications
Floating Point Number parsing: Is there a Catch All algorithm?
How do I print an HTML document from a web service?
Decoding T-SQL CAST in C#/VB.net
Anatomy of a "Memory Leak"
How do I get a distinct, ordered list of names from a DataTable using Linq
Reliable Timer in a Console Application
How do I fill a DataSet or a DataTable from a LINQ query resultset ?
What's the difference between Math.Floor() and Math.Truncate() in .NET?
How do I calculate relative time?
How do I calculate someone's age in C#?
Are there any conversion tools for porting Visual J# code to C#?
When setting a form's opacity should I use a decimal or double?