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?
- 1 Answers
- 20242 Views
- TCS, I also Faced
- E-Mail Answers
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 |
What are the major challenges in accessing data from a database?
What is the meaning of executenonquery?
What is the usage of the dataset object in ado.net?
What is ole data type?
What is disconnected architecture in ado.net?
List all the steps in order, to access a database through ado.net?
ADO.NET is Disconnected Architecture. DataReader is connected Architecture, but DataReader is a part of ADO.NET. How is it possible?
Which object is used to add relationship between two Datatables?
What are the namespaces used in ADO.Net to connect to a database?
What is concurrency? How will you avoid concurrency when dealing with dataset? (One user deleted one row after that another user through his dataset was trying to update same row. What will happen? How will you avoid the problem?)
How to bind the controls(best practice) comboboxes to the data in the dataset?
What is the difference between DataReader and DataSet in ADO.NET?
0 Answers Petranics Solutions,
-
Visual Basic (800) - C Sharp (3816)
- ASP.NET (3180)
- VB.NET (461)
- COM+ (79)
- ADO.NET (717)
- IIS (369)
- MTS (11)
- Crystal Reports (81)
- BizTalk (89)
- Dot Net (2435)
- Exchange Server (362)
- SharePoint (720)
- WCF (340)
- MS Office Microsoft (6963)
- LINQ Language-Integrated Query (317)
- WPF (371)
- TypeScript (144)
- Microsoft Related AllOther (311)
