Before Applying job posting in any websites or recruiting agencies or sending resumes to job recruiters or any other employment website you need to improve your skills on general knowledge, Aptitude, Puzzles, logical reasoning, general english, database, programming as per your job profile. Job recruiters or mostly preferring job candidates who are having more stuff in those categories mentioned above. So improving more skills on your job profile always boost up your career and your performance. Even hiring companies and job recruiters who are looking for many job posting websites actually they are looking and filtering on these activities. In these Ado.net section you need to update more questions to perform well in front of job recruiters and companies. Ado.net Interview questions are most important to score in interview, Update all questions to score well in all rounds in job interview.

ADO.Net interview questions and answers

21)
I want to force the connection object to close after my data reader is closed?

PobjDataReader = pobjCommand. Execute Reader (CommandBehaviour.ScbemaOnly)

22)
What is the use of Command Builder?

Command Builder builds “Parameter” objects automatically. Below is a simple code, which uses command builder to load its parameter objects.

Dim pobjCommandBuilder As New Ole DbCommandBuilder (pobjDataAdapter)
PobjCommandBuilder . Derive Parameters (pobjCommand)

Be careful while using “Derive Parameters” method as it needs an extra trip to the Data store , which can be very inefficient

23)
How can we add relation bet ween tables in a Dataset?

DimobjRelation As DataRelation
objRelation = New
DataRelation (“ CustmerAddresses” , objDataset . Tables (“Customer”) . Columns (“Custid”)
, objDataSet . Tables (“Addresses”) . Columns (“Custid- fk”))
objDataSet . Relations . Add (objRelation)

Relations can be added between “Data Table” objects using the “Data Relation” object. Above sample, code is trying to build a relationship between “Customer”and “Addresses” “Data table” using “Customer Addresses” “Data Relation” object.