Publish c# application in visual studio 2010 with sql server 2008?

Hi, Using Visual Studio you can create a setup project and install prerequisites that you need during installation.The installation process is very simple and the end user can install application and prerequisites after clicking next buttons. Here are the steps for Creating a Setup Project:

Create a Setup Project

Add new project → setup and deployment → setup project
Right Click on Setup project and Add project Output and select primary output from your main project
Right Click on Setup project and Add project Output and select content files from your main project
Right Click on setup project and Click Properties and click Prerequisites and select SQL Server Express
Select .Net Framework
Select Windows Installer
Select radio button Download prerequisites from the same location as my application.
Right Click on Users Desktop at left pane and add new Shortcut and select application folder, primary output from SampleApplication, and click ok and the rename the short cut to what you need.
Rebuild solution.
Rebuild Setup Project
Go to Output directory of setup project and run setup.exe
It's that easy.

1. https://www.c-sharpcorner.com/UploadFile/996353/create-setup-and-deployment-project-in-visual-studio-200820/
2. https://stackoverflow.com/questions/32956142/how-to-deploy-application-with-sql-server-database-on-clients