ADO.NET Interview Questions
Questions Answers Views Company eMail

What are the advantages and drawbacks of using ado.net?

622

Name which operations can you not perform on an ado.net dataset?

486

What are the advantage of ado.net?

521

What are good ado.net object to replace to ado recordset object.

570

What is bubbled event can you please explain?

528

If we are not returning any records from the database, which method is to be used?

757

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?

553

What is the executescalar method?

584

Explain the role of data provider in ado.net?

546

What is isolation?

571

What are the different row versions available in table?

530

If a table contains 20000 records . In a page at each time 100 records to be displayed what are the steps you will take to improve performance? Will you use dataset or datareader?

614

How do you connect to sql server database without using sqlclient?

562

What are the steps to connect to a database?

548

What is connection string?

529


Post New ADO.NET Questions

Un-Answered Questions { ADO.NET }

How many major types of connection objects in ADO.NET?

593


How will you differentiate between ADO (ActiveX Data Object) and RDO (Remote Data Objects)?

586


What are the ado.net objects?

510


Can we do database operations without using any of the ado.net objects?

535


How to add an aggregate column?

535






What is openrowset?

496


Which is faster entity framework or ado.net?

501


What are the steps you will take to improve performance?

463


What is row state?

527


Explain the difference between data reader and data set?

486


What is difference between executequery and executeupdate?

501


In how many ways we can retrieve table records count? How to find the count of records in a dataset?

544


What are the advantage of ado.net?

521


What do you mean by ‘batch updates’?

513


What are two important objects of ADO.Net?

556