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


i creating c# application requires use database , planning create installer application. want ask database best use in application , how install on user machine while installing application through installer file. have thought of using mysql database u need have mysql installed.

update

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

you not have ship full database server application; redistributable runtime application use connect actual database server remotely. in case of mysql, need assemblies.

applications wrote relied heavily on sql server. in order simplify evaluations , initial deployment, installer install sql server express (installed application specific instance). approach i'd recommend if application intended centralised database.

what key understand, commercial application, database engine install may have co-exist existing versions of respective database engine. why application specific instances created sql server express.

the alternatives, embedded, are:

  1. sqlite.net
  2. sql server compact edition. deployment process defined.
  3. vistadb

embedded databases have challenges when deployed part of server application. many years, microsoft refused allow sql server compact edition used asp.net applications. if database per user, per device, embedded database may perfect.

also aware mysql has license restrictions when shipped part of commercial software (aka you're acting oem, isv or var).


Comments

Popular posts from this blog

java.util.scanner - How to read and add only numbers to array from a text file -

rewrite - Trouble with Wordpress multiple custom querystrings -

php - Accessing static methods using newly created $obj or using class Name -