1

I will need to build a C# WPF application with an embedded database (so user does not need to install a database or a database server). My application have concurrently insertion (up to 50) and each 50 of these insertion could occur concurrently every 10ms (so in 10ms I get 50 different data into the same Table).

I will then need to save all these datas together with some setting (e.g. TextBoxes) to a file so I open these data and setting values to the application at a later time.

I am new to database - is SQLite good enough as an embedded database for such application? Does MySQL or PostgreSQL offer something embedded? And can I save a bunch of database data to a file?

0

1 Answer 1

1

SQLite or SQL Server Compact would both work fine for this, from the sound of your requirements.

VistaDB is another potential option, if you want to use the same syntax as SQL Server but need >4GB (CE's limitations).

Sign up to request clarification or add additional context in comments.

Comments

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.