What is an ADO.Net?





1. What is an ADO.Net?
http://blogs.msdn.com/b/microsoft_press/archive/2010/10/28/free-ebook-programming-windows-phone-7-by-charles-petzold.aspx
1.       What is an ADO.Net?
ADO.Net is commonly termed as ActiveX Data Objects which is a part of .Net Framework. ADO.Net framework has set of classes which are used to handle data access by connecting with different databases like SQL, Access, Oracle, etc…
2.       What are two important objects of ADO.Net?
There are two important objects of ADO.Net:
DataReader and .
DataSet.

 3.       What are the namespaces used in ADO.Net to connect to a database?
Following namespaces are used to connect to Database.
The System.Data namespace.
The System.Data.OleDb namespace  –  A data provider used to access database such as Access, Oracle, or SQL.

 The System.Data.SQLClient namespace – Used to access SQL as the data provider.
 4.       What is LINQ?
LINQ is native query language for .NET framework and it is specially designed to support queries with the .net applications. LINQ can be connected to SQL and MS Access.
5.       What are the data providers in ADO.NET framework?
Below Data Providers are used in ADO.NET framework.
.NET Framework Data Provider for SQL Server – A Data provider that provides access to Microsoft SQL Server 7.0 or later version and it uses the System.Data.SqlClient namespace.
.NET Framework Data Provider for OLE DB – A Data Provider that provides access to any database exposed by using OLE DB and it uses the System.Data.OleDb namespace.
.NET Framework Data Provider for ODBC – A Data Provider that provides access to any databases exposed by using ODBC and It uses the System.Data.Odbc namespace.
.NET Framework Data Provider for Oracle – A Data Provider that provides access to Oracle database 8.1.7 or later versions and it uses the System.Data.OracleClient namespace.


6.       What is DataReader Object?
Datareader is an object of ADO.Net which provides access to data from a specified data source. It consists of classes which sequentially read data from a data source like Oracle, SQL or Access.
7.       What is Dataset Object?
A Dataset is set to be collection of data with a tabular column representation. Each column in the table represents a variable and the row represents to value of a variable. This Dataset object can be obtained from the database values.
8.       What is object pooling?
Object pooling is nothing but a repository of the objects in memory which can be used later. This object pooling reduces the load of object creation when it is needed. Whenever there is a need of object, object pool manager will take the request and serve accordingly.
9.       What is connection pooling?
Connection pooling consists of database connection so that the connection can be used or reused whenever there is request to the database. This pooling technique enhances the performance of executing the database commands. This pooling definitely reduces our time and effort.
10.   What is Data view?
Data view is the representation of data in various formats and it can be requested by the users. Data can be exposed in different sort orders or filter on the user condition with the help of Data view. Data Customization is also possible through Data View.

11.   What is Data Adapter?
Data Adapter is a part of ADO.NET data provider which acts as a communicator between Dataset and the Data source. This Data adapter can perform Select, Insert, Update and Delete operations in the requested data source.
12.   What is the use of SqlCommand object?
SQLCommand object that allows user to interact with the database. This object mainly used to query the database and it can be of different types – Select, Insert, Modify and Delete.
13.   What is the difference between ADO and ADO.Net?
ADO works with the connected data whereas ADO.Net works in a disconnected manner. ADO has main object called Recordset which is used to reference data. But ADO.Net has various objects to access the database.
ADO allows creating client side cursors whereas ADO.Net deals with both server side and server side cursors. ADO allows persisting records in XML format and ADO.Net allows to manipulate data using XML.
14.   What are the benefits of ADO.Net?
Following are the benefits of ADO.Net:
Programmability
Maintainability
Interoperability
Performance
Scalability


15.   What is the use of connection object?
ADO.Net Connection object is used to establish a connection between application and the data source. SQL Commands can be executed once this connection has been established. It is mandatory to close the connection object once data base activities are completed.
16.   What are all features of ADO.Net?
Following are the features of ADO.Net:
Data Paging
Bulk Copy Operation
New Data Controls
Datareader’s execute methods.
17.   What is the difference between Response.Expires and Reponse.ExpiresAbsolute?
Response.expires property specify the minutes of page in cache from the time, the request has been served from server.
But Response.ExpiresAbsolute property provides exact time at which the page in cache expires.
Example -
Response.expires – Set to 10 mins and it will stay in cache for 10 mins from time it has been requested
Response.ExpiresAbsolute – Oct 30 12:20:15. Till this specified time, Page will be in cache.
18.   What is boxing and unboxing?
Conversion of value type to reference type is called Boxing and Conversion of reference to value type is called Unboxing. Boxing and Unboxing are used for type casting from value to reference type and vice versa.


19.   What is the difference between Datareader and Dataset?
Following table gives difference between Datareader and Dataset:
Datareader
Dataset
Forward only Loop through Dataset
Connected Recordset Disconnected Recordset
Single table involved Multiple tables involved
No relationship required Relationship between tables maintained
No XML storage Can be stored as XML
Occupies Less Memory Occupies More memory
Read only Can do addition / Updation and Deletion
20.   Is it possible to edit data in Repeater control?
No, it is not possible to edit data in the Repeater control.
21.   What are all components of ADO.Net data provider?
Following are the components of ADO.Net Data provider:
Connection object – Represents connection to the Database
Command object – Used to execute stored procedure and command on Database
ExecuteNonQuery – Executes command but doesn’t return any value
ExecuteScalar – Executes and returns single value
ExecuteReader – Executes and returns result set
DataReader – Forward and read only recordset
DataAdapter – This acts as a bridge between database and a dataset.

22.   What are the differences between OLEDB and SQLClient Providers?
OLEDB provider is used to access any database and provides flexibility of changing the database at any time. SQLClient provider is used to access only SQL Server database but it provides excellent performance than OLEDB provider while connecting with SQL Server database.
23.   What are the different execute methods of Ado.Net?
Following are different execute methods of ADO.Net command object:
ExecuteScalar – Returns single value from the dataset
ExecutenonQuery – Returns resultset from dataset and it has multiple values
ExecuteReader – Forwardonly resultset
ExecuteXMLReader – Build XMLReader object from a SQL Query


24.   What are all the commands used with Data Adapter?
DataAdapter is used to retrieve data from a data source .Insertcommand, UpdateCommand and DeleteCommand are the commands object used in DataAdapter to manage update on the database.


25.   What are all the different methods under sqlcommand?
There are different methods under SqlCommand and they are:
Cancel – Cancel the query
CreateParameter – returns SQL Parameter
ExecuteNonQuery – Executes and does not return result set
ExecuteReader – executes and returns data in DataReader
ExecuteScalar – Executes and returns single value
ExecuteXmlReader – Executes and return data in XMLDataReader object
ResetCommandTimeout – Reset Timeout property

Comments

Post a Comment

Popular posts from this blog

Image
Capricornian Lucky Connections Colour: brown, green, black, gray, indigo Plants: yew, ash, hemp, weeping willow Perfume: musk Starstone: black onyx Metal: lead Tarot Card: the devil Animals: goat, donkey Ruling Planet: Saturn Lucky Numbers: 6, 8 and 9 black onyx Emerald ~ Panna Blue Sapphire ~ Neelam Pearl ~ Moti Blue Lapiz Lazuli
Read more

Now, send free SMS through Gmail chat

Now, send free SMS through Gmail chat It is finally here. The free SMS service right from your Gmail chat window.  Almost a year after the service was introduced in the United States and many other countries, the service has now been made available to Indian users. You could now send a text message to most mobile operators across the country from the comfort of your computer, although there is a prominent exception, at least for users in Bangalore. The Gmail Free SMS service is available for connection to mobile phones with SIMs of many operators, including BSNL, Aircel, Idea, Loop Mobile, MTS, Reliance, Tata DoCoMo, Tata Indicom and Vodafone. However, repeated test messages to Airtel mobiles failed to get the SMSes delivered. Once you send an SMS from the chat window to a mobile phone other than Airtel’s, you wait for a response. The replies will appear as regular chat replies  and conversations will also be stored in your chat history. The new feature was rolled out t...
Read more

CPA Gateway Company Leadbolt Why You Should Use Them

When searching for a CPA company often times you will have a hard time figuring out who to use as many companies sound promising but usually come short on what they promise. Many CPA companies fail to meet payments on schedule, cheat you out of legitimate conversions, or ban your account before you receive payments. Leadbolt isn’t one of those companies that you hear about from other Internet marketers as they are real company founded in the United States with a strong track record among the industry. Leadbolt is defined as a CPA Gateway company like CPA lead. When you visit a website with Leadbolt’s code installed into the website, a blocker will pop up and before they can enter the website they must fill out a survey from a number of advertisers. Once the survey has been filled out you will be paid a commission and the person will be able to enter the website. To incentivize people to fill out surveys to enter the website you can offer downloads, coupons, or adult content etc. Ra...
Read more