Best Stand Alone Database For Laptop in VB.Net?

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • newsaboutgod@gmail.com
    #1

    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?

    Tags: None
    • =?Utf-8?B?S2VycnkgTW9vcm1hbg==?=
      #2
      RE: Best Stand Alone Database For Laptop in VB.Net?

      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


      "newsaboutgod@g mail.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?
      >
      >

        Comment

        • Mark Dykun
          #3
          Re: Best Stand Alone Database For Laptop in VB.Net?

          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
          <newsaboutgod@g mail.comwrote in message
          news:72d446dc-07cd-4131-88ad-74000510c370@d7 0g2000hsb.googl egroups.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?
          >

            Comment

            • Spam Catcher
              #4
              Re: Best Stand Alone Database For Laptop in VB.Net?

              newsaboutgod@gm ail.com wrote in news:72d446dc-07cd-4131-88ad-74000510c370
              @d70g2000hsb.go oglegroups.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.



              --
              spamhoneypot@ro gers.com (Do not e-mail)

                Comment

                Previous template Next
                Working...