Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


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



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 method to get XML and schema from Dataset? getXML() and get Schema ()

0 Answers  


How to check if a datareader is closed or opened?

1 Answers  


What are all the commands used with Data Adapter?

0 Answers  


How to Read, Add, Update and Delete record in Entity Framework ?

0 Answers  


I loaded the dataset with a table of 10 records. One of the records is deleted from the backend, how do you check whether all the 10 records were present while updating the data(which event and steps) and throw the exception 28 can datareader hold data from multiple tables?

0 Answers  


What are disadvantages of microsoft-provided data provider classes in ado.net?

0 Answers  


Define bubbled event?

0 Answers  


What are the different layers of ado.net?

0 Answers  


What is the namespaces being used to access oracle database?

0 Answers  


What are dcl commands?

0 Answers  


Which object needs to be closed?

0 Answers  


How to copy the contents from one table to another table and how to delete the source table in ado.net?

0 Answers  


Categories