Category Archives: ADO.Net Interview Questions

How to find the count of records in a dataset? | ADO.Net Questions

DS.Tables[“tabname”].Rows.Count; we can get count of the records.

Posted in ADO.Net Interview Questions | Leave a comment

what is data Adapter? | ADO.Net Questions

Data adapter is bridge between Connection and DataSet , Data adapter in passing the sql query and fill in dataset.

Posted in ADO.Net Interview Questions | Leave a comment

What is Isolation? | ADO.Net Questions

A transaction is a unit of isolation ? allowing concurrent transactions to behave as though each were the only transaction running in the system. Isolation requires that each transaction appear to be the only transaction manipulating the data store, even … Continue reading

Posted in ADO.Net Interview Questions | Leave a comment

What is Atomicity? | ADO.Net Questions

A transaction is a unit of work in which a series of operations occur between the BEGIN TRANSACTION and END TRANSACTION statements of an application. A transaction executes exactly once and is atomic ? all the work is done or … Continue reading

Posted in ADO.Net Interview Questions | Leave a comment

Explain acid properties? | ADO.Net Questions

The term ACID conveys the role transactions play in mission-critical applications. Coined by transaction processing pioneers, ACID stands for atomicity, consistency, isolation, and durability. These properties ensure predictable behavior, reinforcing the role of transactions as all-or-none propositions designed to reduce … Continue reading

Posted in ADO.Net Interview Questions | Leave a comment

What is the provider and namespaces being used to access oracle database? | ADO.Net Questions

The provider name is oledb and the namespace is system.data.oledb

Posted in ADO.Net Interview Questions | Leave a comment

What provider ADO.net use by default? | ADO.Net Questions

Ado.net uses no Dataprovider by default and this is absulotely correct answer. there is no other choice for this questions.

Posted in ADO.Net Interview Questions | Leave a comment

What we do with the object of ado.net dataset after using it?Can we dispose it or can we set it nothing?Is it must or not? | ADO.Net Questions

we use dispose.

Posted in ADO.Net Interview Questions | Leave a comment

What are the two fundamental objects in ADO.NET? | ADO.Net Questions

Datareader and Dataset are the two fundamental objects in ADO.NET

Posted in ADO.Net Interview Questions | Leave a comment

What are the different row versions available in table? | ADO.Net Questions

There are four types of Rowversions: Current: The current values for the row. This row version does not exist for rows with a RowState of Deleted. Default : The row the default version for the current DataRowState. For a DataRowState … Continue reading

Posted in ADO.Net Interview Questions | Leave a comment