Connect via an IP address using Microsoft.Data.SqlClient

Connection string

This Microsoft SqlClient Data Provider for SQL Server connection string can be used for connections to SQL Server 2019, SQL Server 2017, SQL Server 2016, SQL Server 2014, SQL Server 2012, SQL Server 2008, SQL Server 2005, SQL Server 2000 and SQL Server 7.0.

Data Source=190.190.200.100,1433;Network Library=DBMSSOCN;
Initial Catalog
=myDataBase;
User ID=myUsername;Password=myPassword;

DBMSSOCN=TCP/IP is how to use TCP/IP instead of Named Pipes. At the end of the Data Source is the port to use. 1433 is the default port for SQL Server. Read more here.