Asp.net file database

Question

Is there any simple database system that uses simple text or XML files to store data? I just need some basic features like update, delete, insert, simple constraints and relationships.

For the project that I am currently using SQL Server, it will be too heavy, and I still never liked it.

Answer 1

Yes it is: SQLite :)

There is an ADO provider: http://sqlite.phxsoftware.com/forums/default.aspx?GroupID=2

There is an article about that: http://www.aspfree.com/c/a/Database/Using-SQLite-for-Simple-Database-Storage/

Answer 2

A dataset from the .NET Framework is also an option. See DataSets, DataTables, and DataViews (ADO.NET) on MSDN.

Answer 3

Theoretical:

• XML as a data source
• Manipulate XML file data using C #

These projects will give you an idea.

• Merge your own database
• Using XML as a dataset database

Answer 4

SqlCompact is a great option for this. There is no engine or installation, just turn on the DLL and you can create the database on the fly.

http://www.microsoft.com/downloads/details.aspx?FamilyId=DC614AEE-7E1C-4881-9C32-3A6CE53384D9&displaylang=en

- EDIT: as @MathewMartin said: SqlCompact 4.0 is designed to build a web database and allows multiple connections.

Answer 5

SQLite is a good option.

Since you are using .net, although I would have thought, just using xml and LINQ to XML, it is very sql, as in many ways.

Answer 6

Check this question: Free Portable Database

There you will find a list of "light" databases.

Answer 7

If you prefer an object database , consider using NDatabase .