I was doing a system in c # , I had it connected to a database in access . But I realized that maybe I could not; Generate the installer of the program and pass it to another person.
Someone told me to try to put a database of Sql Server Compact , so, I would not have to worry about putting a connection string like "C:/Users/NombreUsuario/BaseDeDatos.accdb"
What I had to do was add my Sql Server Ce database to the project and put the connection string in App.config of the project.
Add a database by clicking on the name of the project > add > "Service-based database". If I want to change the name, Visual Studio will generate it with the name DataBase1.mdf along with another file called DataBase1DataSet.xsd . But I really do not know how to do it.
Try looking for some tutorials on youtube or in forums. But in many they use a reference to System.Data.SqlServerCe that I do not have and can not download from NuGet.
How can I do it? (Include local database and be able to put it in the project to generate the installer of the program and run it on any computer without server) Greetings and I hope I did not confuse you.
