Reference
Connection URL syntax
Specify information about your database
On this page
Each connection URL must specify the selected ADO.Net Data Provider to connect to the database. This information is provided in the URL scheme (the part of the URL preceding the symbols ://). If you want to connect to a database hosted on Microsoft SQL Server, you can specify the scheme mssql. The scheme for other databases or other ADO.Net providers such as ODBC drivers and OleDb providers can be found here.
You also need to specify the server where the database is located. The server information can be a server name or an IP address. In most cases, you should also specify the database name that you’re targeting. These two information are respectively provided as the host and the first segment. of the URL.
string connectionUrl = "mssql://{server}/{database_name}";
If the port is not the standard port it can be specified after the host and is separated by a symbol colon :.
string connectionUrl = "mssql://{server}:{port}/{database_name}";
A SQL Server database login and password can appear before the host. A colon : separates them and an at sign @ separates the credentials from the host. For other sign-in methods, see Library authentication or CLI authentication.
string connectionUrl = "mssql://{sql_login}:{password}@{server}/{database_name}";
Additional information can be provided as options in the connection URL. The separation between the segments and the first option is marked with a question mark ?. Use the specific keywords expected by the connection string of the Ado.Net Data Provider (specified by the scheme) as the key (left-side) followed by the symbol equal = and then the expected value. Two different options are separated by the symbol ampersand &. If you want to specify that the ConnectRetryCount should be set to 5 and the ConnectRetryInterval should be of 3 seconds, then apply the following connection URL:
string connectionUrl = "mssql://{server}/{database_name}?ConnectRetryCount=5&ConnectRetryInterval=3";
Braced names in these examples are placeholders, not literal URL text. Percent-encode reserved characters in usernames, passwords, and path values (for example, use %40 for an at sign inside a password).