What is the "connectionString" connection string?

Asked

Viewed 2,804 times

9

What is after all to string connecting?

In a string of connection what represents the data-source?

And the provider name?

c# .net sql-server terminology connectionstring

2 answers

8


It is a text that passes the information necessary for the database to establish a connection with the application. You obviously need the address (usually includes the port) where the bank is, what type it is, the form of connection, the user, password, etc.

Just remembering that the ideal is to avoid putting the user and password (especially this one), it is better to let use another type of authentication more secure. But if you use it, at least it’s encrypted.

Has a site dedicated to this.

The Data Source is where the data is. It has several ways to specify the location, it can be an IP, for example. It is the same thing as Server, Address, among others.

ProviderName is not part of the string connection. This can be in the configuration file. Put in it which is the DLL that will be used as a client to access the database. It is in it that has the codes that will establish the connection and all data access communication. This helps define which database will be used and which connection texts will be valid.

  • Thanks Brow... could you tell me how I make the connection of VS2015 with Sqlserver 2016... I’m trying to 3 days and I can’t get anything good

  • This would fit in another question, but no one will be able to do it for you if you don’t know what to put. If the site that I went through doesn’t help you, I have doubts if it will be easy to help you.

  • is that I’m not getting it very well...

  • But thanks all the same

1

Dude you can create the connection string using a .udl. extension file Just create a text file, change the extension to "udl", open the file configure with the data to connect to your database ( Host, username, pass), save this file, change to . txt, open and copy the text in there. Your connection string :is ready) Hug.

Browser other questions tagged c# .net sql-server terminology connectionstring

You are not signed in. Login or sign up in order to post.