用反串行化映射SQL Server数据库

这种方法主要描述不使用Dataset也可以讲数据移出Sql Server数据库，和前者相比的有点在于减少从数据库检索所需要的代码量。

1、Contact类代码：

using System.Xml.Serialization;

/// <summary>
/// Summary description for Contact
/// </summary>
///
[XmlRoot("Contacts")]
public class Contact
{
    public string ID;
    public string FirstName;
    public string MiddleName;
    public string LastName;

    public Contact()
    {
        //
        // TODO: Add constructor logic here
        //
    }
}

2、执行代码：

using System;
using System.Web.Configuration;
using System.Xml;
using System.Xml.Serialization;
using System.Data.SqlClient;

public partial class Default5 : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        Contact cont;
        XmlElementAttribute contIDElement = new XmlElementAttribute();
        contIDElement.ElementName = "ContactID";

        XmlAttributes attributesIdCol = new XmlAttributes();
        attributesIdCol.XmlElements.Add(contIDElement);
        XmlAttributeOverrides attrOverrides = new XmlAttributeOverrides();
        attrOverrides.Add(typeof(Contact),"ID",attributesIdCol);

        string connString = WebConfigurationManager.ConnectionStrings["AdventureWorks"].ConnectionString;
        SqlConnection sqlConn = new SqlConnection(connString);
        sqlConn.Open();
        SqlCommand sqlCommand = new SqlCommand("select ContactID,"+ "FirstName, MiddleName, LastName, EmailAddress from Person.Contact "+ "as Contacts where ContactID=2 for XML Auto, elements", sqlConn);
        XmlReader reader = sqlCommand.ExecuteXmlReader();
        XmlSerializer serializer = new XmlSerializer(typeof(Contact), attrOverrides);
        serializer.UnknownElement+=new
         XmlElementEventHandler(XmlSerializer_UnknownElement);
        if(serializer.CanDeserialize(reader))
        {
            cont=(Contact)serializer.Deserialize(reader);
            Response.Write("<b>反串行化的结果是：" + "</b><br>");
            Response.Write("ID: " + cont.ID + "<br/>");
            Response.Write("FirstName: " + cont.FirstName + "<br/>");
            Response.Write("FirstName: " + cont.MiddleName+ "<br/>");
            Response.Write("FirstName: " + cont.LastName + "<br/>");

        }
        else
        {
            Response.Write("文件不能进行反串行化处理！");
        }
    }

    /// <summary>
    /// Handles the UnknownElement event of the XmlSerializer control.
    /// </summary>
    /// <param name="sender">The source of the event.</param>
    /// <param name="e">The <see cref="System.Xml.Serialization.XmlElementEventArgs"/> instance containing the event data.</param>
    void XmlSerializer_UnknownElement(object sender, XmlElementEventArgs e)
    {
        Response.Write("Unknown Element:" + "<br/>");
        Response.Write("Unknown Element Name: " + e.Element.Name + "<br/>");
        Response.Write("Unknown Element Value: " + e.Element.InnerText + "<br/>");
    }
}

3、执行结果