Complete Guide to XML For Microsoft Developers

XML, XPATH, XSLT, XQuery, XSD, XML in SQLServer, C#, LINQ, and PowerShell, Saxonica

Created by: Neal Walters
BizTalk Consultant

What Will I Learn?

• Uses and History of XML and Basics of Well-Formed XML
• Mapping XML using XSLT (1.0 and 3.0, including Saxon Library)
• XPath (used in XSLT, XQuery, and programming)
• SQL XML, reading XML into SQL, processing XML Columns
• Using C# to Process XML, XPath, XSLT, and XQuery
• Using PowerShell to Process XML
• Creating HTML from XML (using XSLT)
• Extracting and Formatting XML from SQL databases
• Serialization and Deserialization (to and from XML)
• Use of the XSD utility to generate schemas from classes and classes from schemas
• Converting XML to JSON using Newtonsoft Json library
• Using PlugIns to making working with XML easier in Visual Studio, VSCode, and NotePad++

Requirements

• While not required, general knowledge of C# and Visual Studio would be useful
• While not required, experience in some programming language would be useful
• While not required, knowledge of HTML would be useful for one of the exericses

Target audience

• C# developers who want to use XML, XPath, XSLT, and XQuery
• PowerShell developers who want to use XML, XPath, XSLT, and XQuery
• SQL developers who want to use use XML, XPath, XSLT, and XQuery
• BizTalk Integration (Middleware) Developers who want a well-rounded background in XML and the surrounding technologies