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

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

After a long hiatus, let me start with how the new XML data type in SQL Server 2005 is exposed via ADO.Net 2.0. I will discuss this new data type in following parts: XML data type in SQL Server 2005 – A brief Introduction : You can consider this as a crash course on XML…

8