File-based database asp.net

+4 A:

Yes it is: SQLite :)

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

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

dario-g 2010-02-17 23:33:14

Nice, but can I integrate this into my ASP.net application? I am using shared hosting, does the server need to have it installed?

diamandiev 2010-02-17 23:58:02

@diamandiev: No there is no need. You can use sqlite on your shared host.

Daniel Vassallo 2010-02-18 00:15:31

How does this work then? If the server does not have the dll's do I need to just add them to the Bin folder?

diamandiev 2010-02-18 00:26:59

Yes and this is just beautiful :)

dario-g 2010-02-18 11:29:23

A:

Theoretical:

These projects will give you an idea

Asad Butt 2010-02-17 23:33:28

A:

SqlCompact is a great option for this. There is no engine or setup, just include the .dll and you can create a database on the fly.

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

sadboy 2010-02-17 23:34:17

Not working under IIS process by design.

dario-g 2010-02-17 23:36:02

There is an override for it though. AppDomain.CurrentDomain.SetData("SQLServerCompactEditionUnderWebHosting", True)

sadboy 2010-02-17 23:38:06

Yeap. I forgot about it :)

dario-g 2010-02-18 11:30:43

A:

SQLite is a good option.

Since your using .net though, i'd consider just using xml and LINQ to XML, it's very sql like in many ways.

Paul Creasey 2010-02-17 23:38:19

-1: It's like SQL, except for "some basic functionality like update,delete, insert, simple constraints and relations".

John Saunders 2010-02-17 23:41:05

@john, only relational constraints are missing, everything else is possible in a simple and expressive manner.

Paul Creasey 2010-02-17 23:47:45

@Paul: sorry, insert, update and delete are not "simple and expressive", as it's necessary to layer these concepts onto a sequential file format.

John Saunders 2010-02-17 23:58:17

expressive might be a stretch, but it's certainly simple imo!

Paul Creasey 2010-02-18 08:39:23

A:

Check this Stack Overflow question: Free portable database

There you will find list of "lightweight" databases.

zendar 2010-02-18 00:03:01

+1 A:

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

Jakob Gade 2010-02-18 02:09:40

How about persisting the data?

HardCode 2010-02-18 02:13:32

See the WriteXml method: http://msdn.microsoft.com/en-us/library/zx8h06sz.aspx

Jakob Gade 2010-02-18 03:03:00

Ah, right. I forgot about that. Good idea. +1

HardCode 2010-02-18 19:15:29

ansaurus

tags:

views:

answers:

File-based database asp.net

related questions