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

How to Nail the Interview and Land the Job

By: Kasan Groupe | 03/12/2009
Nail your next interview with great tips and suggestions.

Questions to ask in an Interview

By: RedStarResume | 03/12/2009
When the interviewer asks "do you have any questions" always answer YES! Find below a list of the top questions to ask in an interview.

The Most Important Three Words In A Search?

By: Brad Remillard | 02/12/2009
Everyone knows the three most important words in real estate are location, location, location. So then, “What are the three most important words in a job search?” (Answer below)

Honesty + guts works in an interview

By: Brad Remillard | 02/12/2009
Two different situations explain why, no matter how desperate one is for a job, interviewing the same way you would if you had the best job in the world, is the difference between getting an offer and not getting one.

It Is OK to SWEAR In A Job Interview!

By: Brad Remillard | 02/12/2009
There seems to be two types of candidates in this world. Those that ramble on and on hoping if they talk long enough the person will forget the question they asked or the candidate that gives one or two word answers to every question. It is like pulling teeth to get a complete answer.

Busted – Age Discrimination Revealed

By: Brad Remillard | 02/12/2009
Anyone that has read the discussions in our Linkedin Job Search Networking Group knows that I am not a big believer in age discrimination. That doesn’t mean I think it doesn’t happen. What it does mean is that I don’t think it happens as frequently as many candidates do. In fact, I believe it is far more rare than most.

Best Website For Placement Papers is PlacementPapers.asia

By: Asif Khan | 02/12/2009
PlacementPapers.asia is a leading examination papers portal where you can find best placement papers.

It Is Important For Every Job Seeker To Know About The Job Interview

By: Jamie Blizzard | 01/12/2009
When it comes to the job hiring process a company is looking for a strong individual who has experience in their field and the education to support the company in the future.