How do I know what is the connection String?

Question

Hi, I used to work with entity framework and I need not worry what is the connection String blah blah blah. But now, I have to use ADO.net framework I do not know how to write the Connection String based on the Ms SQL Server 2016 I am using. Can someone tells me from where I can know information on the above?

Nitin Sontakke · Answer

Looks like i misread your question. Now I got it. First thing is, are you been able to connect to SQL Server through Management Studio. If yes, you should have user Id, password and a database name. After you succeed in doing above, you can use answer given by Abhilash. The fact that you are talking about Server Properties, probably you have logged in. If yes, did you not use user Id and password? If not, you probably logged in using Windows Authentication. If you are using Windows Authentication, your connection string would be connectionString = "Server=SQlServerName;Database=YouDatabaseName;Trusted_Connection=True;"

Nitin Sontakke · Answer

I cannot buy that you didn't have to worry about connection string while using EF. How were you creating the context? You must definitely had a context name. If yes, go in web.config and you will find a connection string named after your context name there.

Bikesh Srivastava · Answer

Go=>Tools=>Connect to database=>new window will be open fill details. click on ok=>go=>server explorer=.right click=>check property=>connection string,,,that's it

Mani Kandan · Answer

Try this inside Web.Config file. configuration > connectionStrings > add name = "SQLDbConnection" connectionString = "Server=SQlServerName; Database=YouDatabaseName; User Id=userid; password= password" providerName = "System.Data.SqlClient" /> connectionStrings > configuration >

Dilip Gupta · Answer

follow this link for more information: https://msdn.microsoft.com/en-us/library/jj653752(v=vs.110).aspx

Tangara G · Answer

Hi Nitin, I am not using EF so there is no context whatsoever. So, I have to connect directly to the dataSource which is Ms SQL 2016 but I do not know what to put at the Connection String DataSource there at the web.config. Can you pls advise me ?

Tangara G · Answer

Hi Abhilash, Can I know YourDatabaseName is it referring to the name in the Server Properties ? Cos the Server Properties it is using my name.... Also, is it necessary to put in User Id and password ? Where can I find my User Id and password in the system ? Pls clarify. Tks.

How do I know what is the connection String?

Vilas