I want to build a .Net WPF application for users, so they can install themselves. The application required a Database as well and want to add DB file in the installer. So user don't need to install separate DB engine. If any one install the installer application everything will be ready for them. Which DB should I choose?
Asked
Active
Viewed 56 times
-1
-
SQLite is a good option – Sir Rufo Oct 03 '18 at 05:14
1 Answers
1
You can go with SQLite very light weight framework. Make sure you download and install an appropriate System.Data.SQLite setup package
Refer to the below link:
https://system.data.sqlite.org/index.html/doc/trunk/www/index.wiki
Uday Teja
- 263
- 3
- 15
-
I don't know much about **SQLite**, but I answered this question a while back on debugging its use after installation: [Relative path for SQLite not working with WIX Toolset](https://stackoverflow.com/a/52323006/129130). – Stein Åsmul Oct 03 '18 at 14:06
-
Thank you for your answer. DB size is fine for me just thinking about reliability and support. Planning to develop retail application for small business so data is important. Application targeted for single user POS type and its windows native application. – Suman Biswas Oct 04 '18 at 07:27
-
Any idea about SQLite strength on ACID property, especially transactions - commit and roll back feature? – Suman Biswas Oct 04 '18 at 07:33