ADO.NET INTERVIEW QUESTION & ANSWERS
36. |
What is the use of System.Data.sqlclient namespace in ADO.Net? |
|
System.Data.sqlclient : This contains the objects that we use to connect to a data source . This can generally provide better performance as it removes some of the intermediate layers required by an OLE-DB connection. |
37. |
What is the use of System. XML namespace in ADO.Net? |
|
System. XML : This contains the basic objects required to create read, store, write and manipulate XML documents according to W3C recommendations. |
38. |
What is the preferred method for executing SQL commands that contain parameters? |
|
The preferred method is to use the sqlParameter and oleDbParameter objects, as
detailed in the section "Using Parameters with the command Object." |
39. |
What are the two fundamental objects in ADO.NET? |
|
There are two fundamental objects in ADO.NET are :
Datareader - connected architecture and
Dataset - disconnected architecture. |
40. |
What is the use of command object? |
|
This is the responsible object to use stored procedure. |