Lightweight SQL database which doesn't require installation

sql .net database ms-access
Alexander Prokofyev picture Alexander Prokofyev · Nov 7, 2008 · Viewed 24k times · Source

Could you recommend a lightweight SQL database which doesn't require installation on a client computer to work and could be accessed easily from .NET application? Only basic SQL capabilities are needed.

Now I am using Access database in simple projects and distribute .MDB and .EXE files together. Looking for any alternatives.

Answer

Christian C. Salvadó picture Christian C. Salvadó · Nov 7, 2008

Check SQLite, it's a software library that implements a self-contained, serverless, zero-configuration, transactional SQL database engine.

It has many wrappers for .NET

Related questions

How can I create database tables from XSD files?

I have a set of XSDs from which I generate data access classes, stored procedures and more. What I don't have is a way to generate database table from these - is there a tool that will generate the DDL …

Read More
How do You Get a Specific Value From a System.Data.DataTable Object?

I'm a low-level algorithm programmer, and databases are not really my thing - so this'll be a n00b question if ever there was one. I'm running a simple SELECT query through our development team's DAO. The DAO returns a …

Read More
What is the syntax for an inner join in LINQ to SQL?

I'm writing a LINQ to SQL statement, and I'm after the standard syntax for a normal inner join with an ON clause in C#. How do you represent the following in LINQ to SQL: select DealerContact.* from Dealer inner join …

Read More