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

Why ado.net test required for job stream?

ADO.Net test is now important in job stream (Administration, IT software, software testing etc.).In Brightbrainy, you can practice online ADO.Net questions and answers with the explanations in order to face interview, competitive exams like (TCS, Wipro, Infosys, Dell, etc.)

Where fresher and teens can get online ADO.Net question and answers with an explanation?

In bright brainy, students can learn and practice ADO.Net question and answers that it would be strengths, their current academic and its gives path to future career. Here you can find online test ADO.Net questions and answers (technical, computer science, sample TCS, Infosys,Wipro and IT) with explanations for fresher which improve skills to face interview. Brightbrainy provides sample ADO.Net questions and answers with detailed explanation and it would be ease to understand, ADO.Net question and answers available for free download PDF.

Bright brainy offers lots of solved ADO.Net questions

Here you can find lots of ADO.Net question and answers with detailed descriptions. You can download free eBook pdf ADO.Net question and answers.

1)
When should we use System. Data. SqlClient and System. Data . OleDB?

If you to connect only to SQL Server use sqlclient or else use oledb. Oledb also connects to other database plus sql server .Sqlclient is meant specifically meant for SQL server so has better performance as compared to oledb.

2)
How can we fine-tune the command object when we are expecting a single row ?

Again, CommandBehaviour enumeration provides two values Single Result and Single Row. If you are expecting a single value then pass “CommandBehaviour . SingleResult” and the query is optimized accordingly, if you are expecting single row then pass “commandBehaviour. SingleRow” and query is optimized according to single row.

3)
Which is the best place to store connection string in .NET projects?

Config files are the best places to store connection strings. If it is a web-based application “Web.config” file will be used and if it is a windows application “App.config” files will be used.

4)
How do you fill the dataset?

Create object ofdata adapterand call the fill command method of the adapter.

SqldataAdapter objAdapter = new sqlDataAdapter (objCommand) ;
Dataset objDataset = new Dataset () ;
objAdapter . Fill (objDataset);

5)
What are the various methods provided by the dataset object to generate XML ?
  • Read XML
    Read’s a XML document in to Dataset.
  • Get XML
    This is a function, which returns the string containing XML document
  • Writexml
    This writes a XML , data to disk