Interested to Buy Any Domain ? << Click Here >> for more details...
What is ADO .NET and what is difference between ADO and ADO.NET?
- 7 Answers
- 14423 Views
- Ksb, I also Faced
- E-Mail Answers
Answer Posted / satyambabu
The first data access model, DAO (data access model) was
created for local databases with the built-in Jet engine
which had performance and functionality issues. Next came
RDO (Remote Data Object) and ADO (Active Data Object) which
were designed for Client Server architectures but soon ADO
took over RDO. ADO was a good architecture but as the
language changes so is the technology. With ADO, all the
data is contained in a recordset object which had problems
when implemented on the network and penetrating firewalls.
ADO was a connected data access, which means that when a
connection to the database is established the connection
remains open until the application is closed. Leaving the
connection open for the lifetime of the application raises
concerns about database security and network traffic. Also,
as databases are becoming increasingly important and as
they are serving more people, a connected data access model
makes us think about its productivity. For example, an
application with connected data access may do well when
connected to two clients, the same may do poorly when
connected to 10 and might be unusable when connected to 100
or more. Also, open database connections use system
resources to a maximum extent making the system performance
less effective.
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
I loaded the dataset with a table of 10 records. One of the records is deleted from the backend, how do you check whether all the 10 records were present while updating the data(which event and steps) and throw the exception 28 can datareader hold data from multiple tables?
What is the use of SqlCommandBuilder?
Is bulk insert faster than insert?
Explain ado.net features?
What is ole db query?
What are the advantages of ado.net?
How do we use stored procedure in ADO.NET and how do we provide parameters to the stored procedures?
What is untyped dataset?
What is the default provider in ado.net?
What DataReader class do in ADO.NET ?
What is ado and dao?
Explain About ado.net components/objects. Usage of data adapters and tell the steps to retrieve data.
What is ado control?
What is openrowset?
What is data adapter in ado.net with example?
