*ado.net supports to perform the following structure
- Query processing
- Non-query processing
- stored procedure/function handling
1. Query processing:
Retrieves the data from the database with “select statement”
2. Non-query processing
Doesn’t retrieve any data from the database .it insert/delete/updates the data at the database. It is of 6 types.
1. Insertion 2.deletion 3.updation 4.creation tables
5. Droping tables 6.altering a table.
3. Stored procedure /function handling:
Executes a stored procedure/a stored function that is already created at backend.
Ado.net offers some library (in the form of namespaces), in order to interact with the database data.
*the ado.net library is available in the form of namespaces
*API: system. Data;
*in order to perform different database transactions, ado.net offers different classes