What are the differences between RAW, AUTO and Explicit
modes in retrieving data from SQL Server in XML format?
Answer Posted / 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 View All Answers
What is adodb dll?
How to check if the Dataset has records ?
What provider ado.net use by default? Explain the role of data provider in ado.net?
Explain how to find the given query is optimised one or not?
Explain what are the steps to connect to a database?
What are the different namespaces used in the project to connect the database? What data providers available in .net to connect to database?
How would you connect to a database by using .NET?
Explain About ado.net components/objects. Usage of data adapters and tell the steps to retrieve data.
What are the classes in System.Data.Common Namespace?
What is bubbled event can you please explain?
How to generate a single aggregate?
In how many ways we can retrieve table records count? How to find the count of records in a dataset?
What is the difference between sqlcommand and sqldataadapter?
What is the difference between Dataset. clone and Dataset.copy?
What is ambient transaction?