Sharing C# project code with sql database with Professor

Jason Dean

I have a wpf project with a database and I would like to send to him(the professor), how can I export the database with the code without creating a script. I used visual studio SQLEpress 2014 to create the database and connect to the database.

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sachin Singh4y ago
Accepted answer
Just create a folder with the name App_Data. This folder is a normal folder that VS use to place data files.
Jason Dean4y ago
My app does not have App_Data file
Sachin Singh4y ago
In visual studio right click on app_data folder and click on add existing item
and then select database which you want to add in app_data folder it will be in In most case
( C:\Program Files\Microsoft SQL Server\MSSQL10_50.SQLEXPRESS\MSSQL\DATA\yrdatabase.mdf)
and now this database will add in app_data folder

Now change your connectionstring in config file
Copy Code
"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\yrdatabase.mdf;Integrated Security=True;User Instance=True  " name="myCS" providername="System.Data.SqlClient" />
And now the professor will be able to use yr app without any issue.
Srinivasan Ramamoorthi4y ago
Try exporting the wizard mentioned in this link. You can select to export with schema and data.
https://docs.microsoft.com/en-us/sql/integration-services/import-export-data/start-the-sql-server-import-and-export-wizard?view=sql-server-ver15