ADO.NET INTERVIEW QUESTION & ANSWERS
41. |
What .NET tools arc used to automatically generate XML Schemas and typed datasets? |
|
Use either Visual Studio or the XSD.exe tool. |
42. |
What are different types of Commands available with DataAdapter ? |
|
The SqlDataAdapter are :-
Select Command
- Insert Command
- Delete Command
- Update Command
|
43. |
What is the use of data adapter? |
|
These objects connect one or more command objects to a Dataset object. An OleDb Data Adapter object is used with an OLE-DB provider.
A Sql Data Adapter object uses Tabular Data Services with MS SQL Server. |
44. |
What is a DataSet? |
|
A DataSet is an in memory representation of data loaded from any data source. |
45. |
What method is used by the command classes to execute commands that do not return resultsets, such as the SELECT COUNT command? |
|
The Execute Non Query method executes SQL commands that don't return a result set. |