What database should I use in a Windows Forms application to make it work without installing Sql Server?

Question

C++ / C#

Hello, this is my first question on the toaster, if I'm doing something wrong, please tell me.
The problem is this. I've been learning C# for a couple of months now. Now I got to the Entity Framework, I wrote a Windows Forms program that displays data in the DataGridView from the database and, using Entity, allows you to add / edit / delete data from the database. So the whole thing works fine on my computer, but when I stuff it all into the installer and install it on another computer, the program does not work - it hangs in the processes, but the form is not visible. As I understand it, you need to use some kind of light database to work without installing a server. But no matter how much I dug into the Internet, I could not solve the problem. Either I stumbled upon Sql Server Compact, then found out that it was no longer supported, then on localDB, but it didn’t work with it either, I was tortured in short. Tell me, pliz, what kind of small software base to use and, if not difficult, a link to the tutorial for it.
Py.Sy. Advise another installer normal. I use the Visual Studio Installer plugin, but it doesn't really suit me, it doesn't always build. Thank you all in advance))

Answer 1

Do you know a lot of desktop applications that use a local database? Desktops typically use a file server architecture. If you really want a database, then it's better to take SQLite

Answer 2

MySQL(I)

Answer 3

Легко встроить MS SQL сервер в свой инсталятор с помощью так называемого "пакета распостранения". Вот только я не помню детали такой операции :) Но если сильно надо то можно поискать.