locked
Good database for C# deployment? RRS feed

  • Question

  • I have an application in C# but still not decided on which database to use. I have these choices but still not decided which database is good to deploy? My concern is more on deployment and just letting to the client to click install and thats it, no need to install this, that application, if you know what I mean. :D My choices are:
    1. MsSQL (.mdf or service-based database embedded in C#).
    2. MySQL.
    3. Firebird.
    4. Access
    • Moved by Amanda Zhu Tuesday, June 11, 2013 2:35 AM not VS general forum issues and not sure which appropriate forum this thread can be moved to
    Saturday, June 8, 2013 6:43 AM

Answers

All replies

  • I only have experience with Acces and MsSQL.  Don't use Access in shared mode because conflict can ocur when multiple users try to read/write same data at the same time.  Also don't use MsSQL mdf in shared mode for same reason.  The MsSQL Server handles the Multi-User environment.

    MsSQL only has to be installed on one PC (the server) and the other client user PCs can remote access the server database using oledb connection provided the right credentials are setup in both the Windows User Account on the server, and the credentails for the database.


    jdweng

    Saturday, June 8, 2013 9:50 AM
  • I know it was not one of your options, but then again, you may not know about this option and you're already using C#... If you're talking about easy deployment, you're talking about SQL Server Compact Edition, the embedded database engine ( http://www.microsoft.com/en-us/sqlserver/editions/2012-editions/compact.aspx ). It can be deployed just by including a DLL.

    Kind regards,
    Margriet Bruggeman

    Lois & Clark IT Services
    web site: http://www.loisandclark.eu
    blog: http://www.sharepointdragons.com

    • Proposed as answer by Just Karl Tuesday, June 18, 2013 2:18 PM
    • Marked as answer by Just Karl Thursday, June 27, 2013 2:57 PM
    Tuesday, June 18, 2013 1:31 PM
    Answerer