Simple access to a sql .db3 file using .NET - how?

tags:

.net
sql

views:

645

answers:

2

Q:

Simple access to a sql .db3 file using .NET - how?

Lost in the talk of ADO, LinQ and System.Data.SQLite.

What's the easiest way of accessing (for read & write) a SQL (.db3) database file using .NET. Are we really talking about writing SQL queries or is there something higher level that is provided by MS or similar.

A:

System.Data.SQLite is the ADO.net adapter for SQLite (so those two are the same). LINQ2SQL is a data layer generator, but it only works for SQL Server.

Matt Briggs 2009-07-22 14:02:48

+1 A:

go here:

http://sqlite.phxsoftware.com

You will absolutely not find a better, more complete or more polished solution. And it's free, public domain source code too.

Nathan Ridley 2009-07-22 14:09:56

+1, that's what i use for professional projects.

Clement Herreman 2009-07-22 14:16:03

but does it still need to write SQL and do things with connection strings, DataAdapters and Datasets or is there a class based way now?

McBainUK 2009-07-22 14:59:17

I don't think you understand your own question, or at the very least are not articulating it very well. If it helps, it is a full ADO.Net solution with support for everything from data readers to data adapters through to LINQ to Entities support. If that still doesn't answer your question, it sounds like you need to do a bit more learning on the topic of database access in .Net in general.

Nathan Ridley 2009-07-22 15:06:14

Re-reading my question I realize I wrote 'does it' when I meant 'do I'. Either way after reading some of the documents on LINQ and Entities with SQLite it seems like that's a good a way to go. Thanks for the pointers

McBainUK 2009-07-22 15:35:37

ansaurus

tags:

views:

answers:

Simple access to a sql .db3 file using .NET - how?

related questions