using a small foot print database for application such as VistaDB

[Newbie]

Hi,

I am looking at an application that stores a very small amount of data, but
needs a database to hold the data.

SQL Express is just way to big for this, and requires its own installation
which is simply not an option.

I have read up on VistaDB, but would be keen to hear what others have used
with vb.net. SQLite looks ok, but I am not sure if it works well with the
..net environment.

I want to be able to just have the database install with my application and
not have the end user have to do anything to configure it


Thanks

 

[Miro]

When posting to multiple groups - add all the newsgroups to your address....
so people do not have to reply multiple times to your same issue.

As stated in microsoft.public.dotnet.languages.vb.data ,
have a look at the old ms access database or take a look at storing the data
in an XML file.

M.

 

[Teemu]

Hi,

I am looking at an application that stores a very small amount of data,
but
needs a database to hold the data.

SQL Express is just way to big for this, and requires its own installation
which is simply not an option.

I have read up on VistaDB, but would be keen to hear what others have used
with vb.net. SQLite looks ok, but I am not sure if it works well with the
.net environment.

I want to be able to just have the database install with my application
and
not have the end user have to do anything to configure it

Have you looked at this one:
http://www.microsoft.com/sqlserver/2008/en/us/compact.aspx

It is fully supported in VS IDE, also in Express Editions.

-Teemu

 

[Michel Posseth [MCP]]

Personally i would go for SQL server everywhere edition wich is now called
SQL server CE
it has a one dll runtime, is xcopy deployable and has the ability to upscale
to a full featured SQL server database

 

[Cor Ligthert[MVP]]

Hi,

You are not asking this as the first one.

However, it comflicts with current data handling mainly because currently
most data need to be concurrently sharable with other users and other
programs.

As your data is not to complex and does not need to be shared between other
programs in the same time, you can go for an XML file.

As it is even more simple then the issolated storage is created for your
question.

http://msdn.microsoft.com/en-us/library/system.io.isolatedstorage.aspx

However, the last decenium is the DataBase the way to go, because seldom
people wants programs where the data is isolated to a user of a program.

Cor