I want to deploy a database application in C#. I should write a script for creating a database and its tables.
The script should work only at install time and setup the database automatically. Or tell me if there is another better way to do that.
Actually I wanted to deploy this application on another PC. but connection string and login permissions to the database are causing problem.
What I have tried is:
1. Created a database using SQL management studio.
2. copied database file to Client PC.
But that did not work.
Then I tried adding a new database project to my solution. That also did not work.
The application runs fine on my own PC where I have developed this project.