C# Corner
Tech
News
Videos
Forums
Trainings
Books
Live
More
Interviews
Events
Jobs
Learn
Career
Members
Blogs
Challenges
Certifications
Bounties
Contribute
Article
Blog
Video
Ebook
Interview Question
Collapse
Feed
Dashboard
Wallet
Learn
Achievements
Network
Refer
Rewards
SharpGPT
Premium
Contribute
Article
Blog
Video
Ebook
Interview Question
Register
Login
.NET
ADO.NET
Android
ASP.NET
C#
Databases & DBA
Design Patterns & Practices
Java
Learn iOS Programming
OOP/OOD
SharePoint
Software Testing
Web Development
WPF
View All
2
Reply
What are the benefits of ADO.NET?
Rohan Rathore
12y
2.7k
0
Reply
Delete Row
Delete Column
Insert Link
×
Insert
Cancel
Embed YouTube Video
×
Width (%)
Height (%)
Insert
Cancel
Table Options
×
Rows
Columns
First row as header
Create Table
Insert Image
×
Selected file:
Alignment
Left
Center
Right
Select an image from your device to upload
Upload to Server
Cancel
Submit
the main benefit of ADO .NET is it is a DATA ACCESS TECHNOLOGY which can be used to communicate with different datasources.which in tern it works as a mediator between the database servers and applications
Srinivas Pabballa
10y
0
BENEFITS OF ADO.NET1>Scalability:- ADO.NET works on DataSet that can represent a whole database or even a data table as a disconnected object and thereby eliminates the problem of the constraints of number of databases being connected. In this way scalability is achieved. 2>Data Source Independence:- In ADO.NET DataSet is completely independent of data source and no way DataSet is controlled by the data source as it happens in case of RecordSet. 3>Interoperability:- As ADO.NET transmits the data using the format of XML which is not dependent on ADO.NET or windows platform. 4>Strongly Typed Fields:- It supports strongly typed fields by using CTS. 5>Performance:- The performance in ADO.NET is higher in comparison to ADO that uses COM marshalling. 6>Firewall: As in ADO.NET transmission is via XML format, therefore it can pass through firewalls.
Munesh Sharma
11y
0
What is a Command Object?
What is the use of Connection Object?
Message