Geek Answers Handbook

Which database can be distributed as part of the backend of a C # application

I plan to write and commercialize a C # application that will store data in the base database. I use MySQL in my environment for my own development, and this is what I would use to write the application for myself (there is no need to use the FK - MyISAM mechanism will OK).

My concern is how easy it will be to distribute the application along with the database engine. Will using MySQL allow me to easily package a client-side one-click installation? (i.e. I don’t want them to install MySQL themselves), and is this also possible from the point of view of licensing?

Are there other database systems that will make the process more direct.

+5
source share
7 answers

The key here is which database you need. Is this database accessible to multiple users of the application? If so, then MySQL will be fine.

But it looks like you are going to use this database as a private data warehouse, where each installed application instance has its own local data for this computer or profile. In this case, you need a built-in engine such as Sql Server Compact Edition, Sqlite or even Access, and not a server engine like MySql or Sql Server Express Edition.

+1
source

Take a look at SQL Server Compact 3.5

+7

Sqlite . DLL . , , .

+4

, SQLite , , .

Access , Microsoft Office, , Odbc OleDb, GAC.

+2

, - yor. , Firebird Embedded

+1

SQL Server 2008 Express is available to redistribute third-party software vendors. You also deploy this using the Microsoft Web Platform installer.

0
source

SQL Server Express is another option. It has excellent integration with .NET, free installation and support for up to 10 GB per database (or more if you use the Filestream function).

0
source

More articles:


All Articles