Best Stand Alone Database For Laptop in VB.Net?

  • Thread starter Thread starter newsaboutgod
  • Start date Start date
N

newsaboutgod

I need a stand alone database for a VB.Net application on a laptop.

It will have about 15,000 records in it.

Frst off, if there any way to load XML in to a dataset and then run
SQL against it? Maybe that would meet my need.

If not, what is the best or quickest stand alone database for vb.net
and a laptop?
 
Frst off, if there any way to load XML in to a dataset and then run
SQL against it? Maybe that would meet my need.
Click to expand...

A dataset has a ReadXml and WriteXml properties and has a sort of
limited SQL abilities. Basically all the Sql stuff is there, you just
have to use it a bit different than you would against Sql Server.
If not, what is the best or quickest stand alone database for vb.net
and a laptop?
Click to expand...

I'd go with the strongly typed datasets, they have the functionality
you need and even support things like relationships. You might even
look at using some LINQ, but I can't say much about it as I do not use
LINQ. If you need better performance, my recommendation would be to
use SQL Server Compact Edition or SQL Server Express. If you design
your program properly though, you could easy just swap out the data
tier later on if performance becomes an issue.

Thanks,

Seth Rowe [MVP]
 
newsaboutgod,

You can't execute sql commands against a datatable/dataset (although there
are some third-party tools promising that capability).

You can however do selection and filtering on the data in a
datatable/dataset, which might meet your needs.

There are a number of databases available that might meet your needs. For
example, Microsoft's new SQL Server Compact Edition (I think that is their
current name for the product), Firebird, etc.

Of course, a laptop could also run SQL Server Express or Access. Or one of
the open source databases, like MySQL or PostGreSQL.

Kerry Moorman
 
OK, so SQL CE3.5 is a Standalone in process database. Is there a reason you
could not use it. You can execute SQL, create tables, and use the upcomming
sync framework with it. At 15,000 records do you not want some form of
indexing to ensure the best performance. I think the database Dlls are only
around 2mb total distributable.

Mark
 
(e-mail address removed) wrote in @d70g2000hsb.googlegroups.com:
I need a stand alone database for a VB.Net application on a laptop.

It will have about 15,000 records in it.
Click to expand...


You can use Vista DB, SQL Server CE, or even Embedded Firebird.

SQL Server CE is probably the best choice since it's free and has VS.NET
2005/2008 integration.
 
A laptop with 1000 Gb harddisk?

I assume that those 15000 records can be written in any way on that and just
your personal preference.

If there was one "Best" then the others would not be used.

Cor
 
Back
Top