Explain ado.net features? Benefits? Drawbacks?



Explain ado.net features? Benefits? Drawbacks?..

Answer / Km Sanjita

Features: 1. ADO.NET data providers for SQL Server, OLE DB, Oracle, and others. 2. DataSet, DataTable, and DataView objects to manipulate and navigate data. 3. DataBindings to bind data controls like GridViews and ListViews. Benefits: 1. Simple object-oriented design. 2. Strong integration with the .NET Framework. 3. Cross-platform support for various databases. Drawbacks: 1. Slightly slower performance compared to native drivers for some databases. 2. Lacks advanced features like caching or connection pooling that are available in higher-level ORM (Object Relational Mapper) tools.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More ADO.NET Interview Questions

what is the syntax code to oledb to connect oracle

6 Answers   IBM,


Describe connection object in ado.net

1 Answers  


Which object of ado contains datarow datacolumn collection?

1 Answers  


how to keep track of index in listbox items.

2 Answers  


What provider ado.net use by default? Explain the role of data provider in ado.net? What is the role of data provider in ado.net?

1 Answers  


What is ADO .NET and what is difference between ADO and ADO.NET?

7 Answers   Ksb,


What is a datagrid?

4 Answers  


What is the difference between SqlCommand and SqlCommandBuilder?

1 Answers  


what is connection pooling ?

3 Answers   Vertex,


What are the types of databinding?

1 Answers  


What is ado and rdo?

1 Answers  


Data reader read and forward only, how is it possible to get 2 tables of data at a time?

1 Answers  


Categories