What is the role of Connection String in ADO.NET? Why we use it?
What is connection string in ADO.NET?
Ask by Ethan Karla
Updated 07 Jul 2021
Connection String are the normal string representation which contains the database connection information to connect it with application to the database to perform the CRUD operation. Database String includes parameters such as the name of the Server, Database name, Driver, Port as well as security credentials to connect with database such as Username and password.
Data Providers uses connection string with a collection of arguments to connect with the database through applications. Usually .NET Framework provides mainly three data providers :
1.) Microsoft SQL Server
2.) OLEDB
3.) ODBC