*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 library:
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
Latest posts by DuttaluruVijayakumar (see all)
- how to create ASP.NET Core 3 Web API Project - January 21, 2022
- JWT Authentication using OAUTH - January 10, 2022
- Ado.net database Transactions - January 9, 2022