469,658 Members | 1,844 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,658 developers. It's quick & easy.

Best Stand Alone Database For Laptop in VB.Net?

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?

Feb 8 '08 #1
3 4463
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?

Feb 8 '08 #2
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?

Feb 8 '08 #3
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)
Feb 8 '08 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Tom Jones | last post: by
9 posts views Thread by none | last post: by
13 posts views Thread by Allan Cammish | last post: by
7 posts views Thread by Ulrich Wisser | last post: by
reply views Thread by gheharukoh7 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.