Hello, I have some questions about best practices and way when creating application with database, some of these questions may look stupid but I need to get the ideas:
1. when I create application with database and after deploying it, when I install it on new PC what must be on the the new PC to work normally on it?
2. If it is not deployed, how to solve the problem of installing SQL Server and making database installed while installing the program?
3. when I create application with database did the database deployed with the application?
4. while I am creating the application, if I use the connection string it will have static information, but this info will be different on the other PC, right? If yes, how to solve this problem?
5. How can I check the database existence and connection when I starting up my program?
6. How to secure information saved in class where they are not accessible easily?