ADO.NET is a database technology that is based on the .NET Framework. This technology provides us with a set of classes through which we can query databases, establish connections, receive a response from the database, and perform a number of other operations.
It is important to note that there can be many types of database management systems:
•
MS SQL Server uses the language
T-SQL
•
MySQL and
Oracle use the language
PL-SQL.
Different database systems can have different types of data.
The
ADO.NET functionality is designed to provide developers with a common interface for working with different databases.