Best Stand Alone Database For Laptop in VB.Net?

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

[=?Utf-8?B?S2VycnkgTW9vcm1hbg==?=]

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
"ne**********@gmail.com" wrote:

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?

[Mark Dykun]

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
<ne**********@gmail.comwrote in message
news:72**********************************@d70g2000 hsb.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.

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?

[Spam Catcher]

ne**********@gmail.com wrote in news:72d446dc-07cd-4131-88ad-74000510c370
@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.

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.

--
sp**********@rogers.com (Do not e-mail)