Deploy a .exe and dependent .dll

I have console project. It is developed in VS2010. It uses Mysql.net connector.

When I was developing in my machine, Every thing wo开发者_Go百科rked fine.

I copied the .exe to my friends laptop and tried to run it, but I got an error telling that Mysql.data.client not found.

I copied all the dlls in to the project folder. Everything worked fine.

Is there any way I can can build the .exe in such a way that I dont have to copy the Mysql.data.client to the other machine.

"Building .exe with all dependencies." Is that possible?

Please let me know.

You can create a Setup Project to add to your Solution.

http://msdn.microsoft.com/en-us/library/19x10e5c%28v=VS.100%29.aspx

This will create an installable application (.msi) with all the included dependencies of your project.