Updated : Jan 09, 2022 in Articles

Ado.net database Transactions

*ado.net supports to perform the following structure

  1. Query processing
  2. Non-query processing
  3. 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)
Like
Like Love Haha Wow Sad Angry

Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments
0
Would love your thoughts, please comment.x
()
x