How to deploy SQL Server Database with my C# Winform app ?

ahmed elakrab

As our "Programming institute" final project I need to develop a Winform app that calculates a plant productivity and stuff..So I have created a database in SQL server 2014. And I was wondering how could I put that database with my .exe in one installation file -to be used you know on other PCs -using InstallShield Limited Edition for Visual Studio with Visual Studio 2012

Any suggestions please..thanks in advance

3 Replies

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

Ali Khan7y ago
Got the right answer??
Sujeet Suman10y ago
Please once follow below process:

Step 1 : Open Solution Explorer -->Right Click on project-->Add-->New Items-->Service-based Database-->Click Add.

Step 2 : Now Double click on Database.mdf file

Step 3 : Now open App.config file from Solution Explorer --> change the connection string details like below -

connectionString="Data Source=.;AttachDbFilename=|DataDirectory|\Database1.mdf;Initial Catalog=test;Integrated Security=True"providerName="System.Data.SqlClient"/>
After these, the database file will auto attach to the sql server when you run your application.

Now you can use connection string like below:

ConfigurationManager.ConnectionStrings["AttachedDBConnectionString"].ConnectionString

If this is helpful for you then please accept my Answer.
Kashif Sohail10y ago
I will suggest you to add database file in your project. While you are creating the setup for the application, in prerequisites, check the specified version of SQL server. It will help you to deploy the application.