Learn how to serialize .NET classes to Xml at runtime using System.Xml.Serialization.XmlSerializer. Then, use SQL Server's OPENXML functionality to bulk load hundreds of records across multiple tables in a single stored procedure call.
Platform(s): Windows
Date: Oct, 15 2004
Author: Robbe D. Morris, http://www.eggheadcafe.com/articles/xmlserializer_bulkload.asp