E-Books for you

Contact
WHERE ContactID > 19977
Figure 7-2 shows the results pane.
Figure 7-2
You have successfully read data from an XML file and inserted it into a database. Not difficult to do, was
it? By now you should be realizing how easy LINQ to XML and LINQ to SQL make working with XML
and SQL databases.
Next you??™ll update the new record.
150
Chapter 7: LINQ to XML and Other LINQ Data Models
Update
This example continues the previous one by updating the record that was just inserted. First, though,
you??™ll need to update the XML file Contacts.Xml with the following highlighted
code lines:


19978
0

Scott
Lindsey
Klein
ScottKlein@SqlXml.com
1
F57E03FEA2FD0F74684C20758110CC7860F67523
/RPjvXw=


Next, update the code behind the XML to SQL button of the form with the following highlighted code
lines:
AdventureWorks db = new AdventureWorks("Integrated Security=sspi");
XElement xel = XElement.


Pages:
240 241 242 243 244 245 246 247 248 249 250 251 252 253 254 255 256 257 258 259 260 261 262 263 264