DRAG DROP
You are developing an application that will populate an extensive XML tree from a Microsoft
SQL Server 2008 R2 database table named Contacts.
You are creating the XML tree. The solution must meet the following requirements:
Minimize memory requirements.
Maximize data processing speed.
You open the database connection.
You need to create the XML tree.
How should you complete the relevant code? (To answer, drag the appropriate code
segments to the correct locations in the answer area. Each code segment may be used
once, more than once, or not at all. You may need to drag the split bar between panes or
scroll to view content.)
Answer: 
I believe the second box answer is wrong, it should be the XElement and not the XAttribute as contacts. You can not have XElemets as childs of an XAtrribute.
8
0
Not 100 procent sure you are wrong, but contact is a attribute, while contacts is an element?
0
1
Joe is right, correct answer should be
XElement contacts =
new XElement(“contacts”,
1
0
Correct!
The following doesn’t generate a valid xml:
XAttribute contacts = new XAttribute(“contacts”,
1
0
I think the answer is this.
XNamespace ew = “ContactList”;
XElement root = new XElement(ew + “Root”);
Console.WriteLine(root);
XElement contact = new XElement(“contacts”,
//XAttribute contacts = new XAttribute(“contacts”,
from c in list
orderby c.ContactId
select new XElement(“contact”, new XAttribute(“contactId”, c.ContactId),
new XElement(“firstName”, c.FirstName),
new XElement(“lastName”, c.LastName))
);
root.Add(contact);
1
0
2.4.
1
0
I totally agree with you!
0
0
I agree with 宾宾 too.
0
0
The second box is wrong, it must be XElement, not XAttribute, please correct the answer for this site.
1
0