I am following https://docs.microsoft.com/en-us/ef/core/get-started/aspnetcore/new-db to learn how to use the new .Net Core and Entity Framework Core and I am trying to create the connection string to a remote SQL Server. I updated the server and database strings but it does not show how to specify the username and password. I have done some digging but every entity framework core example I find is for localDB only. How am I to properly specify the login credentials and what should
Trusted_Connection be set to for a remote SQL 2016 R2 server?
The connection strings in EF Core remain the same as in EF6 and when you use pure ADO.NET.
For user/password authentication it's
For a list of common connection strings for SQL Server (and others), look at https://www.connectionstrings.com/sql-server/.
There is small difference in the connection string for the core.You can find it in the MSDN Blog.
we need to specify the server port number in the connection string.
Server = tcp:<ServerName>,<PortName>; Database = <DataBaseName>; User Id = <UserName>; Password = <Password>;
To get the server port number using the following query.
select distinct local_net_address, local_tcp_port from sys.dm_exec_connections where local_net_address is not null