Sign Up Login


  1. Categories >> Software >> Microsoft Related >> ADO.NET
  2. Suggest New Category

What are the differences between RAW, AUTO and Explicit
modes in retrieving data from SQL Server in XML format?

Question Posted / guest


What are the differences between RAW, AUTO and Explicit modes in retrieving data from SQL Server in..

Answer / shobana

RAW

The RAW mode takes the query result and transforms each row
in the result set into an XML element with a generic
identifier row as the element tag and the columns in the
SELECT as attributes.

AUTO

The AUTO mode returns query results in a simple, nested XML
tree. Each table in the FROM clause for which at least one
column is listed in the SELECT clause is represented as an
XML element. The columns listed in the SELECT clause are
mapped to the appropriate element's attributes. The columns
can be optionally mapped to subelements. The nesting of the
elements or hierarchy in the result set is based on the
order of tables identified by the columns specified in the
SELECT clause. The leftmost table will be the top element.
The second leftmost table (identified by columns in the
SELECT statement) will be nested within the top element, and
so on.

EXPLICIT

In EXPLICIT mode, you can explicitly define the shape of the
resulting XML tree. Using this mode requires that the
queries be written in a specific way, so that additional
information about the desired nesting is specified
explicitly as part of the query.

Is This Answer Correct ?    7 Yes 2 No

Post New Answer

More ADO.NET Interview Questions

What is a control toolbox?

0 Answers  

What are the three Ado objects?

6 Answers   Microsoft, StarSoft,

Describe ado.net object model in detail.

0 Answers  

What are different types of Commands available with DataAdapter ?

1 Answers   Arigo Infotech,

What is partial class?

0 Answers  

suppose we using gridview contrl,with sqldatasource.in that for birth date how can we take validation contrl for dd/mm/yy formator how we assign regular expression for same

9 Answers   TCS,

What is difference between executequery and executeupdate?

0 Answers  

Explain the role of data provider in ado.net?

0 Answers  

How to store data in memory?

0 Answers  

What is difference between entity framework and ado.net?

0 Answers  

If we want to connect to many databases in dataaccess layer such as MSAccess,Sql server,oracle means not to a particular database depends on condition we have to connect to appropriate database in this scenario if we without changing code Ho wdo you handle this situation?

4 Answers   Honeywell,

What is adodb dll?

0 Answers  

For more ADO.NET Interview Questions Click Here
Categories