Welcome to FoxLearn In this tutorial, I'll show you how to create a setup file with sql database in visual studio To play demo, you can create a simple window form application allows you to search data from your the sql database. Right-click on your project, then select Manage Nuget Packages to install the Dapper ORM As you know, Dapper is an open source library that makes it easy to access your database Open your app.config file, then add a connection string that allows you to access your sql database We will create an application that connects to the Northwind database to retrieve data from the customer table If you don't already have a Northwind database, you can download it from the fox-learn website. You can create a helper class to read the connection string from your app.config file You need to create a customer class to map the data returned from the customer table in the Northwind database From visual studio toolbox drag a datagridview, textbox and a button to your window form, then add a datasource to the datagridview Double click on the search button, then add your code to handle search data from the customer table To retrieve data from your sql database, you can excute the sql query, then map the data returned to the customer class If you want to get a list of customers, you should convert the Query method into a customer list To create a setup with the sql database, you need to detach your database, then copy your database into your project You should modify your connection string allowing you to dynamically attach your sql database to the sql server Right click on your solution, then add a setup project to your solution If you don't have a visual studio installer, you can download and install it from the extensions and updates tool You need to add the executable file and the sql database file to your Application Folder You can also create a shortcut to your desktop screen, then drag the shortcut to the User's Desktop or User's Programs Menu You can also add a requirement to install the DotNet framework before installing your application Click on the setup project, then select the properties tab, you can enter a manufacturer, product name, description...etc for your setup file To find the setup file, you can right click on your setup project then select Open Folder in FileExplorer, you can find the setup file in the release folder Thank you for watching this video
