What is the "connectionString" connection string?
What is the connection string after all?
In a connection string What does data-source represent?
Or provider name?
2 answers
Is a text that passes the information necessary for the database to establish a connection with the application. Obviously need the address (usually includes the port) where the bank is, what type it is, the connection form, 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 more secure authentication. But if you use it, let it at least be encrypted.
Has a website dedicated to this .
Data Source is where the data is. It has several ways to indicate the location, it can be an IP, for example. It's the same thing as Server, Address, among others.
ProviderName it is not part of the connection string. This can be in the configuration file . It is placed in it which is the DLL that will be used as a database access client. It is in it that has the codes that will establish the connection and all communication of access to the data. This helps define what database will be used and what connection texts will be valid.
Cara you can create the connection string using an extension file .udl. Just create a text file, change the extension to" udl", open the file configure with the data to connect with your bank ( Host, username, pass), save this file, change to .txt, open and copy the text in there. Your connection string is ready :) Hug.