I'm working on my programming assignment, and would like the program to store data in a sql database. I have done this by using SqlConnection and SqlCommand variables/methods. My issue is that this program connects to a database on my pc, so when I submit it for marking, the program will not work, because the lecturer doesn't have the database.

a) Is there a way to store a full database as part of a visual studio project? b) Is there a way to submit the database alongside the program in such a way that the connection string will not need to change?

1 Answers

programmer444 On

If your programs database has not to be connected to the internet you can use SQLite.

If you need an online database you have to run a server with a public ip address so the connection string must not be changed.