Following are some major differences between both :-
• In ADO we have recordset and in ADO.NET we have dataset.
• In recordset we can only have one table. If we want to accommodate more than one tables we need to do inner join and fill the recordset. Dataset can have multiple tables.
• All data persist in XML as compared to classic ADO where data persisted in Binary format also.
| ADO | ADO.NET | |
| Business Model | Connection-oriented Models used mostly | Disconnected models are used:Message-like Models. |
| Disconnected Access | Provided by Record set | Provided by Data Adapter and Data set |
| XML Support | Limited | Robust Support |
| Connection Model | Client application needs to be connected always to data-server while working on the data, unless using client-side cursors or a disconnected Record set | Client disconnected as soon as the data is processed. DataSet is disconnected at all times. |
| Data Passing | ADO objects communicate in binary mode. | ADO.NET uses XML for passing the data. |
| Control of data access behaviors | Includes implicit behaviors that may not always be required in an application and that may therefore limit performance. | Provides well-defined, factored components with predictable behavior, performance, and semantics. |
| Design-time support | Derives information about data implicitly at run time, based on metadata that is often expensive to obtain. | Leverages known metadata at design time in order to provide better run-time performance and more consistent run-time behavior. |
Following are some major differences between both In ADO we have recordset and in ADO.NET we have dataset. In recordset we can only have one table. If we want to accommodate more than one tables. We need to do inner join and fill the recordset. Dataset can have multiple tables. All data persist in XML as compared to classic ADO where data persisted in Binary format also. - See more at: http://www.intrwsqa.com/2015/04/adonet-interview-questions-and-answers-part-1.html#sthash.P8jZh0UO.dpuf
Following are some major differences between both In ADO we have recordset and in ADO.NET we have dataset. In recordset we can only have one table. If we want to accommodate more than one tables. We need to do inner join and fill the recordset. Dataset can have multiple tables. All data persist in XML as compared to classic ADO where data persisted in Binary format also. - See more at: http://www.intrwsqa.com/2015/04/adonet-interview-questions-and-answers-part-1.html#sthash.P8jZh0UO.dpuf
Following are some major differences between both In ADO we have recordset and in ADO.NET we have dataset. In recordset we can only have one table. If we want to accommodate more than one tables. We need to do inner join and fill the recordset. Dataset can have multiple tables. All data persist in XML as compared to classic ADO where data persisted in Binary format also. - See more at: http://www.intrwsqa.com/2015/04/adonet-interview-questions-and-answers-part-1.html#sthash.P8jZh0UO.dpuf
Following are some major differences between both In ADO we have recordset and in ADO.NET we have dataset. In recordset we can only have one table. If we want to accommodate more than one tables. We need to do inner join and fill the recordset. Dataset can have multiple tables. All data persist in XML as compared to classic ADO where data persisted in Binary format also. - See more at: http://www.intrwsqa.com/2015/04/adonet-interview-questions-and-answers-part-1.html#sthash.P8jZh0UO.dpuf
No comments:
Post a Comment