What are the advantages of ADO.NET?

Author Topic: What are the advantages of ADO.NET?  (Read 633 times)

Offline chinmay.sahooTopic starter

  • Trade Count: (0)
  • Full Member
  • ***
  • Thank You 2
  • Posts: 139
  • Karma: 0
    • No Addiction
What are the advantages of ADO.NET?
« on: 02-27-2016, 04:30:16 »
The advantages of ADO.NET are as follows:-
It is not dependent on live connection
The data can be cached in Datasets
Data Source independent of Datasets
The data’s are persisted in the XML
Data Structure are defined by schemas

Offline Gabrel

  • Trade Count: (0)
  • Newbie
  • *
  • Thank You 0
  • Posts: 6
  • Karma: 0
Re: What are the advantages of ADO.NET?
« Reply #1 on: 03-01-2016, 06:41:20 »
Key Benefits:-

ADO.NET applications can take advantage of the flexibility and broad acceptance of XML.

software architects can choose to divide the server's business-logic processing and user-interface processing onto separate tiers on separate machines. In effect, the application server tier is replaced with two tiers, alleviating the shortage of system resources.

ADO.NET data components in Visual Studio encapsulate data access functionality in various ways that help you program more quickly and with fewer mistakes. ADO.NET data classes generated by the designer tools result in typed datasets. This in turn allows you to access data through typed programming.

For disconnected applications, ADO.NET datasets offer performance advantages over ADO disconnected recordsets. When using COM marshaling to transmit a disconnected recordset among tiers, a significant processing cost can result from converting the values in the recordset to data types recognized by COM. In ADO.NET, such data-type conversion is not necessary.

ADO.NET accommodates scalability by encouraging programmers to conserve limited resources. Because any ADO.NET application employs disconnected access to data, it does not retain database locks or active database connections for long durations.

Offline TomClarke

  • Trade Count: (0)
  • Hero Member
  • *****
  • Thank You 14
  • Posts: 896
  • Karma: 0
Re: What are the advantages of ADO.NET?
« Reply #2 on: 04-19-2016, 05:20:49 »
It has some advantages:
- ADO.NET does not depend on continuously Live connections;
- database interactions are performed using data commands;
- data can be cached in datasets;
- datasets are independent of data sources;
- data is persisted as XML;
- schemas define data structures.

Offline technodesign

  • Trade Count: (0)
  • Semi-Newbie
  • *
  • Thank You 0
  • Posts: 18
  • Karma: 0
Re: What are the advantages of ADO.NET?
« Reply #3 on: 07-06-2016, 03:20:52 »
Advantages of ADO.NET.

- Scalability
- Interoperability
- Data Source Independence
- Strongly Typed Fields
- Higher Performance


Related Topics

  Subject / Started by Replies Last post
39 Replies
Last post 05-18-2012, 03:51:14
by Abbey14

Started by SeoDezin « 1 2 » Alexa Ranking

17 Replies
Last post 11-25-2013, 00:29:33
by emedianetwork
36 Replies
Last post 04-19-2012, 06:04:35
by serviceuncle
14 Replies
Last post 09-30-2016, 06:54:50
by mylofu
24 Replies
Last post 03-30-2016, 08:19:18
by sonth321