Interview Tips or Guides on ADO dot Net

<h1>Interview Tips or Guides on ADO dot Net</h1>Author: <a title="Adam Sturo" href="http://www.articlesbase.com/authors/adam-sturo/18045.htm">Adam Sturo</a> ADO.NET come from its previous version that is ADO. It is disconnected and ADO is connected on the other hand. Locking can also be done in ADO.NET and in it all the data can be map with the XML and One of most significance feature of ADO.NET is DataProvider. This data provider can access diffreent data just like SQL, Oracle, Access and do some beautifull task like update, delete, insert and manage database. it provides object to achieve functionalities like opening and closing connection, retrieve data, update data and many more.There are the four main sections of a data provider. (1) Connection. (2) Command object (3) Data Adapter (4) Datareader Datareader and Dataset are the two fundamental objects in ADO.NET. DataReader provides forward-only and read-only access to data on the other side. Dataset is a disconnected architecture while datareader is connected architecture. There are some of data provider ADO.NET namespace:- System.data :-Its contains objects that are used to access and store relational data example DataSet,DataTable, and DataRelation. Each of these is independent of the type of data source and the way we connect to it. System.Data.OleDB:-Its contain objects that are for connecting to a data source with the help of OLE-DB provider, example OleDbConnection, OleDbCommand, etc. These objects comes from the common base classes and same properties, methods, and events as the SqlClient equivalents. System.Data.SqlClient:-Its contains the objects that are used to connect to a data source TDS interface of Microsoft SQLServer. System.XML:-Last but most important these day is System.XML its Contains the basic objects required to create, read, store, write, and manipulate XML documents according to W3C recommendations. Note:- (1)OleDbConnection object is used with an OLE-DB provider (2)SqlConnection object uses Tabular Data Services (TDS) with MS SQL Server (3)System.Data.SqlClient is used for the sql database on the other hand System.Data.Oledb is used for data base that are in Access,Excel etc.About the Author: To read more <a href="http://www.interviewqsn.com/dot-net-interview-questions/index.html">dot net interview questions</a> or any <a href="http://www.interviewqsn.com">interview questions</a> visit InterviewQsn.comArticle Source: <a href="http://www.articlesbase.com/">ArticlesBase.com</a> - <a href="http://www.articlesbase.com/interviews-articles/interview-tips-or-guides-on-ado-dot-net-963868.html" title="Interview Tips or Guides on ADO dot Net">Interview Tips or Guides on ADO dot Net</a>

ADO.NET come from its previous version that is ADO. It is disconnected and ADO is connected on the other hand. Locking can also be done in ADO.NET and in it all the data can be map with the XML and One of most significance feature of ADO.NET is DataProvider.

This data provider can access diffreent data just like SQL, Oracle, Access and do some beautifull task like update, delete, insert and manage database. it provides object to achieve functionalities like opening and closing connection, retrieve data, update data and many more.There are the four main sections of a data provider.

(1) Connection.

(2) Command object

(3) Data Adapter

(4) Datareader

Datareader and Dataset are the two fundamental objects in ADO.NET. DataReader provides forward-only and read-only access to data on the other side. Dataset is a disconnected architecture while datareader is connected architecture.

There are some of data provider ADO.NET namespace:-

System.data :-Its contains objects that are used to access and store relational data example DataSet,DataTable, and DataRelation. Each of these is independent of the type of data source and the way we connect to it.

System.Data.OleDB:-Its contain objects that are for connecting to a data source with the help of OLE-DB provider, example OleDbConnection, OleDbCommand, etc. These objects comes from the common base classes and same properties, methods, and events as the SqlClient equivalents.

System.Data.SqlClient:-Its contains the objects that are used to connect to a data source TDS interface of Microsoft SQLServer.

System.XML:-Last but most important these day is System.XML its Contains the basic objects required to create, read, store, write, and manipulate XML documents according to W3C recommendations.

Note:-

(1)OleDbConnection object is used with an OLE-DB provider

(2)SqlConnection object uses Tabular Data Services (TDS) with MS SQL Server

(3)System.Data.SqlClient is used for the sql database on the other hand System.Data.Oledb is used for data base that are in Access,Excel etc.

To read more dot net interview questions or any interview questions visit InterviewQsn.com

Rate this Article:

0 / 5 stars - 0 vote(s)

Re-Publish

Article Source: http://www.articlesbase.com/interviews-articles/interview-tips-or-guides-on-ado-dot-net-963868.html

Article Tags: interview, questions, dot net, ado dot net

Related Videos
Related Articles
Ask / Related Q&A

Play

How to Become the Best Author

Play

The Importance of Publishers

Play

How to Get your Book Published

Play

BluePhoenix.tv -- Interview with Eric and Simon of iPoc

Play

Home Birth No. 4: The Birth

Latest Interviews Articles
More from Adam Sturo

Illegal Interview Questions: How to Respond to Illegal Questions

By: Andrea | 08/11/2009
The law prohibits discrimination on the basis of age, sex, race, origin and religion. One would hope that the vast majority of interviewers know which questions not to ask, but you never know what to expect so it's always a good idea to be ready for any questions that probe your personal life.

Firefighter Oral Board Interview

By: Brandon | 08/11/2009
Pass your next Firefighter Interview

You Must Adapt Your Job Search To The Company's Culture and Style

By: Brad Remillard | 07/11/2009
Our job search coaching and facilitation programs for candidates take us down many different paths. Every program has to be unique to the needs of the candidate. No two job searches are alike and there is never a one-size-fits-all approach to a job search. Customizing our coaching programs is the hallmark of our success. One example of this happened towards the end of the process with one of our sales and marketing executives.

There is No Time for On The Job Training While in a Job Search

By: Brad Remillard | 07/11/2009
A job search is much like a cable news show, you have to get your point across in sound bites. You often don't have time to give a detailed answer. Candidates need to get comfortable with doing this.

Are You Speaking the Right Language During the Interview?

By: Brad Remillard | 07/11/2009
Candidates too often focus exclusively on the verbal communication aspects of a job search. How much time have you spent on the body language aspect of communications?

Placement Papers a need to get a good job

By: Asif Khan | 07/11/2009
Placement Papers does a very important role to get right job in right company. Companies Placement Papers and exam papers gives an exact idea about the knowledge of the student who is Appling for the job.

Tips To Get Dream Fresher Jobs in India

By: Asif Khan | 07/11/2009
Fresher Jobs i s a big job industry in india where everyone looks for big brand companies.Every gradaute student look for a fresher jobs after college.

Web Camera Job Interviews and Cost Effective Recruiting

By: Shaun Hummel | 06/11/2009
Web conferencing is available FREE of charge allowing recruiters to interview candidates from their office and setting up video interviews between their distant clients and candidates at the recruiter office. Some recruiters often have to interview candidates for 10 minutes at their office before approving resume submittal and clients of course want to do personal interviews unless it is a contract. Having the option to offer personal interviews is a selling point.