Type of database connection in ADO.NET

Type of database connection in ADO.NET.

SQL Connection
This object connects to the SQL Server.

Oracle Connection
This object is used to connect oracle database.

Oledb connection
This object is used to connect MS Access or MySQL(third party database).

Apart from these connections, ADO.NET also allows access to XML files using Dataset object's ReadXML and WriteXML method.
Components of data providers in ADO.NET
ADO.NET - Components of data providers in ADO.NET - The Connection Object: The Connection object represents the connection to the database. ....
Connected and disconnected data access in ADO.NET
ADO.NET - Connected and disconnected data access in ADO.NET - This object requires exclusive use of the connection object. It can provide fast and forward-only data access. It doesn't allow editing....
CommandType property of a SQLCommand in ADO.NET
ADO.NET - CommandType property of a SQLCommand in ADO.NET - A SQLCommand has CommandType property which can take Text, Storedprocedure or TableObject as value.
Post your comment

Related Content

Follow us

▲