All geek questions in one place

Which database should I choose?

I use winforms to develop a desktop application, and now I plan to use the SQL Server Express service, but the problem is that if I use SQL Server Express, the installation is very difficult, I need to install sql server first and install my own application.

Then I tried to use 2003 access as my database, then I only need to copy the mdb file with my application. But the access function is not so strong, the text length is limited to 255 bytes.

Is there any other database solution that is easy to integrate into my application and easy to install after developing my application?

Many desktop applications have their own database and are easy to install and use, which database do they use?

+4
source share
3 answers

SQLite Extremely durable and easy to use, it also has C # bindings. This is currently the most widely deployed embedded database . DLL is less than 300 KB.

+12
source

Use SQL Server Compact Edition (CE). It is free and comes with Visual Studio. It is file-based, but can easily synchronize with a "real" SQL Server database.

I was about to publish a list of links to SQL CE information, but I found too many good links with the following search: http://social.msdn.microsoft.com/Search/en-US?query=sql+server+compact+edition .

+3
source

you can try Non-Sql db like Db4o , this is:

  • easy to set up
  • simple learning curve
  • C # native
  • Object oriented
  • A light weight
+2
source

Source: https://habr.com/ru/post/1304062/

More articles:


All Articles