When I want to debug a .net console application, which process to connect to?
You are joining the application itself. A console application is no different from a winforms or wpf application in this sense.
You should attach to the name of the process you want to debug. Typically this name is the same as the project name when opened in Visual Studio.