Typed XML in ADO.Net v2.0

In the earlier sections, we have been looking at Untyped XML which are different from Typed XML. Typed XML data type is an XML defined with an associated xml schema in Sql Server 2005. You may ask if there is anything different on how Typed XML are exposed via ADO.Net 2.0. The answer is a heart-warming NO!. Typed…

0

XML Data type in ADO.Net v2.0 – Part II

In this section we will look at ways ADO.Net v2.0 (Code named ‘Whidbey’) allows us to insert/delete/update Xml data values in a table containing Xml column in SQL Server 2005 (Code named ‘Yukon’).  With earlier versions of the .Net Framework (1.0 and 1.1) the System.Data.SqlClient namespace will consume and emit XML as String values.Because of…

6