CODEWITHSUNDEEP
c#mysqldatabaseinstallation
Kratos
Kratos

Reputation: 205

Database to use when creating an installer for your c# application

I am creating a c# application which requires to use a database and i am also planning to create an installer for my application. I just want to ask which database would be best to use in my application and how do i install it on a user machine while installing my application through installer file. I have thought of using MYSQL database but for that u need to have MYSQL installed.

Update

i want each user to have there own instance of database when they install the application

Upvotes: 1

Views: 1300

Answers (4)

bloudraak
bloudraak

Reputation: 6002

You do not have to ship a full database server with your application; only the redistributable runtime which your application would use to connect to the actual database server remotely. In the case of MySQL, you only need the assemblies.

Applications I wrote relied heavily on SQL Server. In order to simplify evaluations and the initial deployment, the installer would install SQL Server Express (installed as an application specific instance). This is an approach I'd recommend if your application is intended to a centralised database.

What is key to understand, especially with commercial application, is that the database engine you install may have to co-exist with existing versions of the respective database engine. That is why application specific instances was created for SQL Server Express.

The alternatives, which are embedded, are:

  1. SQLite.net
  2. SQL Server Compact Edition. The deployment process is well defined.
  3. VistaDB

Embedded databases have some challenges when deployed as part of a server application. For many years, Microsoft refused to allow SQL Server Compact Edition to be used for ASP.NET applications. If the database is per user, per device, an embedded database may be perfect.

Also be aware that MySQL has license restrictions when shipped as part of commercial software (aka you're acting as an OEM, ISV or VAR).

Upvotes: 1

Dannydust
Dannydust

Reputation: 773

My advice would be using SQL Azure.

But only if:

  • You don't need much storage (<1GB).
  • You don't save sensitive Data there.
  • Your users have an internet connection.

It's a cloud based Sql Server Database. And the Conneciton is very simple, basically you connect like to any other Database via the Connection String.

www.windowsazure.com

Upvotes: 0

ElDog
ElDog

Reputation: 1377

Have a look at SQL Server Express Edition.

It's just a file which you can copy and a class library which allows to access it. And after you finished your installation you can just delete the files (or to keep them if you need them to uninstall the product).

Upvotes: 1

China江正
China江正

Reputation: 1

may be u are a fresh.

MYSQL is ok ,but u are creating a C# application,i strongly advise you use mssql because C# has a close relationship with mssql,develop more convenient.

Upvotes: 0

Related Questions