Explain Connection String used in ADO.Net?

Posted By: Avi

Date: 2 December 2009 12:04:03 AM

Answer:

When .Net application connects to a database or a data file, ADO.Net uses a connection provider specific to the type of database. We need to supply the Connection String to the connection provider. The connection string contains the information that the provider need to know to be able to establish a connection to the database or the data file. For example, the provider needs the address of the database server (or the path to the data file), name of database, login credentials for the database, etc. and all these information is supplied through Connection String.
Posted By: eTechPlanet	Date: 2 December 2009 12:04:03 AM
When your application connects to a database or a data file you let ADO or ADO.Net utilize a provider to do the job for you. The connection string contains the information that the provider need to know to be able to establish a connection to the database or the data file. This can be done localy on your computer, on your local network or even over internet. The whole procedure is the same, whether you're using standard dsl or highly advanced mobile broadband connections.
Posted By: Johndecruse	Date: 10 February 2010 02:27:36 AM