It is possible to connect to your WordPress server using VS Community Edition application. However, while installing Visual Studio Community you should also install ASP.NET and Web Tools (in here installed 17.10.344.38934). Without this you cannot connect to the WEB.
After installing the above (the ASP.NET and Web Tools can be installed from within an Open Visual Studio window), you can connect to the WEB as shown.
When you click Web to connect, you will get this response.
Finding the FTP site of WordPress:
On WordPress FTP is not supported on any kind of plan, be it premium or business. WordPress uses the Secure File Transfer Protocol (SFTP) for secure file transfers.
SFTC access is tied to the subscribers of the Business or eCommerce plans. If you are on any other plan, you need to upgrade.
You need to access the WordPress server's from your site as shown.
I only have a premium plan and I have no access.