Results 1 to 6 of 6

Thread: What is the best portable / file based database to use within a C# .NET project

  1. Feb 23rd, 2015, 02:31 PM #1
    Webman19
    Webman19 is offline

    Thread Starter
    Junior Member
    Join Date
    Dec 2014
    Posts
    29

    What is the best portable / file based database to use within a C# .NET project

    I know that PostgreSQL is great. But I am in need of a filebased database that should be used within a C# program I am building. I have heard about SQLite and Firebird, but I have no clue which system is best. Thanks.
    Reply With Quote Reply With Quote
  2. Feb 23rd, 2015, 03:09 PM #2
    techgnome
    techgnome is offline
    Smooth Moperator techgnome's Avatar
    Join Date
    May 2002
    Posts
    34,538

    Re: What is the best portable / file based database to use within a C# .NET project

    well "best" is relative... there's also SQLCE (SQL Server Compact Edition) ... but it all depends on what your needs really are. There's going to be some amount of feature loss with portable formats.

    the "best" one is the one that best fits your needs. How simple does the DB need to be? How complex? You can also go with an Access database. By portable, do you mean throw it on the thumb drive and take it with you? Or are you looking for cross-platform portability?

    -tg
    * I don't respond to private (PM) requests for help. It's not conducive to the general learning of others.*
    * I also don't respond to friend requests. Save a few bits and don't bother. I'll just end up rejecting anyways.*
    * How to get EFFECTIVE help: The Hitchhiker's Guide to Getting Help at VBF - Removing eels from your hovercraft *
    * How to Use Parameters * Create Disconnected ADO Recordset Clones * Set your VB6 ActiveX Compatibility * Get rid of those pesky VB Line Numbers * I swear I saved my data, where'd it run off to??? *
    Reply With Quote Reply With Quote
  3. Feb 23rd, 2015, 03:36 PM #3
    Webman19
    Webman19 is offline

    Thread Starter
    Junior Member
    Join Date
    Dec 2014
    Posts
    29

    Re: What is the best portable / file based database to use within a C# .NET project

    Quote Originally Posted by techgnome View Post
    well "best" is relative... there's also SQLCE (SQL Server Compact Edition) ... but it all depends on what your needs really are. There's going to be some amount of feature loss with portable formats.

    the "best" one is the one that best fits your needs. How simple does the DB need to be? How complex? You can also go with an Access database. By portable, do you mean throw it on the thumb drive and take it with you? Or are you looking for cross-platform portability?

    -tg
    Thanks techgnome for the valuable information. Actually, my program should run only under Windows. By portable I mean file based. Thanks.
    Reply With Quote Reply With Quote
  4. Feb 23rd, 2015, 03:52 PM #4
    techgnome
    techgnome is offline
    Smooth Moperator techgnome's Avatar
    Join Date
    May 2002
    Posts
    34,538

    Re: What is the best portable / file based database to use within a C# .NET project

    then it's just a matter of laying out what your NEEDS are, and seeing which one matches the best.

    -tg
    * I don't respond to private (PM) requests for help. It's not conducive to the general learning of others.*
    * I also don't respond to friend requests. Save a few bits and don't bother. I'll just end up rejecting anyways.*
    * How to get EFFECTIVE help: The Hitchhiker's Guide to Getting Help at VBF - Removing eels from your hovercraft *
    * How to Use Parameters * Create Disconnected ADO Recordset Clones * Set your VB6 ActiveX Compatibility * Get rid of those pesky VB Line Numbers * I swear I saved my data, where'd it run off to??? *
    Reply With Quote Reply With Quote
  5. Mar 3rd, 2015, 04:45 PM #5
    abhijit
    abhijit is offline
    PowerPoster abhijit's Avatar
    Join Date
    Jun 1999
    Location
    Chit Chat Forum.
    Posts
    3,226

    Re: What is the best portable / file based database to use within a C# .NET project

    This is a very opinion based question, as tg pointed out.

    My opinion is to use SqlCe, but that's just my opinion and yours may differ.
    Everything that has a computer in will fail. Everything in your life, from a watch to a car to, you know, a radio, to an iPhone, it will fail if it has a computer in it. They should kill the people who made those things.- 'Woz'
    save a blobFileStreamDataTable To Text Filemy blog
    Reply With Quote Reply With Quote
  6. Mar 5th, 2015, 02:24 PM #6
    Lightning
    Lightning is offline
    Frenzied Member Lightning's Avatar
    Join Date
    Oct 2002
    Location
    Eygelshoven
    Posts
    1,611

    Re: What is the best portable / file based database to use within a C# .NET project

    I;ve had great pleasure from sqlite, it even runs on Linux + Mono
    VB6 & C# (WCF LINQ) mostly


    If you need help with a WPF/WCF question post in the NEW WPF & WCF forum and we will try help the best we can

    My site

    My blog, couding troubles and solutions

    Free online tools
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width