The Data Source key is used to find the machine on which the Sql Server instance runs.
You can have different strings for it but the most common used in a LAN environment is composed using the name of the server machine followed by an eventual instance name.
So, if your local PC is named GURUBEAST-PCand, at install time, you haven't specified any instance name, the connectionstring Data Source contains only the name of the machine GURUBEAST-PC.If you have an instance name then you should add that instance name to you Data Source key.GURUBEAST-PCGURUSQLThis will guarantee to all the PC in the same LAN the possibility to have the same connectionstring also if the connection is made from the same PC where the SQL Server runs.If the Data Source points at the local pc, you can use many shortcuts to represent the local PC:
(LOCAL)
localhost
..and eventually add the instance name to these shortcuts without repeating the PC name
Posted by: Guest
on March-12-2021
Code answers related to "c# entity framework core sql connection string"
Forgot your account's password or having trouble logging into your Account? Don't worry, we'll help you to get back your account. Enter your email address and we'll send you a recovery link to reset your password. If you are experiencing problems
resetting your password contact us
Check Your Email and Click on the link sent to your email