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

Question

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 I nstallShield Limited Edition for Visual Studio with Visual Studio 2012 Any suggestions please..thanks in advance

Sujeet Suman · Answer

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=TrueproviderName=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 Sohail · Answer

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.