What are the advantages of ADO.NET?

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

Offline chinmay.sahooTopic starter

  • Trade Count: (0)
  • Full Member
  • ***
  • Thank You 2
  • Posts: 153
  • 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)
  • Semi-Newbie
  • *
  • Thank You 0
  • Posts: 24
  • Karma: 0
Re: What are the advantages of ADO.NET?
« Reply #1 on: 03-01-2016, 06:41:20 »
Key Benefits:-

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

Maintainability
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.

Programmability
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.

Performance
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.

Scalability
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 17
  • Posts: 897
  • Karma: 0
  • Gender: Male
    • Custom Writing Service & Content Marketplace
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.
Your ideas, our writings - Writology.com

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
7047 Views
Last post 05-18-2012, 03:51:14
by Abbey14
Advantages

Started by SeoDezin « 1 2 » Alexa Ranking

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