Easiest database to use (free)?

[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

[Cor Ligthert]

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

[Chris Taylor]

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,

--
Chris Taylor
http://dotnetjunkies.com/weblog/chris.taylor

"Wraith Daquell" <WD******@gmail.com> wrote in message
news:11**********************@f14g2000cwb.googlegr oups.com...

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

[Stefan Simek]

Wraith Daquell wrote:

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

Have look at SQLite (www.sqlite.org)

HTH,
Stefan

[Cor Ligthert]

Chris,

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

The first has a data limit I am not sure I thought 4Gb however read in the
newsgroups 2Gb.

Cor

[Cor Ligthert]

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

[Chris Taylor]

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,

--
Chris Taylor
http://dotnetjunkies.com/weblog/chris.taylor

"Wraith Daquell" <WD******@gmail.com> wrote in message
news:11**********************@f14g2000cwb.googlegr oups.com...

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

[Stefan Simek]

Wraith Daquell wrote:

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

Have look at SQLite (www.sqlite.org)

HTH,
Stefan

[Cor Ligthert]

Chris,

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

The first has a data limit I am not sure I thought 4Gb however read in the
newsgroups 2Gb.

Cor

[Ziga Jakhel]

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


"Wraith Daquell" <WD******@gmail.com> wrote in message
news:11**********************@f14g2000cwb.googlegr oups.com...

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

[Ziga Jakhel]

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


"Wraith Daquell" <WD******@gmail.com> wrote in message
news:11**********************@f14g2000cwb.googlegr oups.com...

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 Daquell]

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)???

[Wraith Daquell]

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)???

[Paul Clement]

On 28 Apr 2005 20:19:05 -0700, "Wraith Daquell" <WD******@gmail.com> wrote:

¤ 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)