Easiest database to use (free)?

  • Thread starter Thread starter Wraith Daquell
  • Start date Start date
W

Wraith Daquell

Hello all,
I am searching for a free database to use with .NET. I haven't worked
with databases much but can manipulate them with a small knowledge of
SQL; I need to be able to store possibly large amounts of data, and the
database should probably be only one or so files. Also, there will not
be a server in the distributed application, just the database and the
application itself. Can anybody help me?
TIA-AA
-WDaquell
 
Wraith,

Are you not asking to much for free, there are people who develop for
profession, so they want to earn something.

Just my thought,

Cor
 
Hi,

Can you define large amounts of data?

Depending on the answer to the above, you might be able to use and MS Access
..mdb as a database.
Just to clear one common misconception up, this does *not* require that MS
Access be installed on the machine,
the mdb can be used independently.

Alternatively you might investigate using MSDE (or the up comming SQL Server
2005 Express).

Best Regards,
 
Wraith said:
Hello all,
I am searching for a free database to use with .NET. I haven't worked
with databases much but can manipulate them with a small knowledge of
SQL; I need to be able to store possibly large amounts of data, and the
database should probably be only one or so files. Also, there will not
be a server in the distributed application, just the database and the
application itself. Can anybody help me?
TIA-AA
-WDaquell
Click to expand...

Have look at SQLite (www.sqlite.org)

HTH,
Stefan
 
Chris,
Alternatively you might investigate using MSDE (or the up comming SQL
Server
2005 Express).
Click to expand...
The first has a data limit I am not sure I thought 4Gb however read in the
newsgroups 2Gb.

Cor
 
db4Objects
www.db4o.com

Extremely easy to use, works very nicely.
Just be aware that it's an object database, not a relational one, so you
work with objects & store objects.Really a nice tool, especially for smaller
projects.
They also have great newsgroup support (db4o.users).

Personally, I'm currently testing it on a several GB database and so far it
works nicely.

Regards,

Sigmund Jakhel
 
Thanks for all your responses.
This application will store student information for teachers, so
depending on how each school uses it, it could store anything from 1 to
500 students (classes, grades, etc, for every year). Sorry for not
being clearer about that.
Ziga, I'll look into db4Objects. I believe this is what I need, though
I did look into MDB (I don't own Access, though... bummer).
I'm really quite a noob when it comes to databases and such, so you may
find more ignorant questions from me in the future :) .

-WDaquell

PS Chris Taylor, are you the REAL Chris Taylor (Dungeon Siege and
all)???
 
¤ Hello all,
¤ I am searching for a free database to use with .NET. I haven't worked
¤ with databases much but can manipulate them with a small knowledge of
¤ SQL; I need to be able to store possibly large amounts of data, and the
¤ database should probably be only one or so files. Also, there will not
¤ be a server in the distributed application, just the database and the
¤ application itself. Can anybody help me?

It isn't free but you may want to check it out anyway:

http://www.vistadb.net/


Paul
~~~~
Microsoft MVP (Visual Basic)
 
Back
Top