What is the role of Connection String in ADO.NET? Why we use it?
What is connection string in ADO.NET?
49807-Jul-2021
Updated on 07-Jul-2021
forum
Home / DeveloperSection / Forums / What is connection string in ADO.NET?
An enthusiastic, adaptive, and fast-learning person with a broad and acute interest in the discovery of new innovative drugs, I particularly enjoy collaborating with scientists from different disciplines to develop new skills and solve new challenges.
1 Answers
Anonymous User
08-Jul-2021Connection 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