using System;
using System.Collections.Generic;
using System.Text;
using System.Data.SqlTypes;
using System.Xml;
using System.Xml.Serialization;
using System.IO;

namespace ConsoleApplication1
{
    class Program
    {
        static void Main(string[] args)
        {
            byte[] b1 = new Byte[4];
            b1[0] = (byte)'a';
            b1[1] = (byte)'b';
            b1[2] = (byte)'c';
            b1[3] = (byte)'d';

            bool btest = true;

            SqlBinary Test = new SqlBinary (b1);
            SqlByte ByteTest = new SqlByte((byte)'a');
            SqlBoolean bTest = new SqlBoolean(true);
            SqlBytes bytesTest = new SqlBytes(b1);
            SqlSingle singleTest = new SqlSingle(4567.4567);
            SqlXml xmlTest;

            XmlSerializer serbin = new XmlSerializer(typeof(SqlBinary));
            XmlSerializer serbyte = new XmlSerializer(typeof(SqlByte));
            XmlSerializer serbool = new XmlSerializer(typeof(SqlBoolean));
            XmlSerializer serbytes = new XmlSerializer(typeof(SqlBytes));
            XmlSerializer sersingle = new XmlSerializer(typeof(SqlSingle));
            XmlSerializer serxml = new XmlSerializer(typeof(SqlXml));
            StringWriter sw = new StringWriter();
            XmlTextWriter xw = new XmlTextWriter(sw);

            serbin.Serialize(xw, Test);
            StringReader sr = new StringReader(sw.ToString());
            serbin.Deserialize(sr);
            sr.Close();
            xw.Close();
            sw.Dispose ();
            sr.Dispose ();

            sw = new StringWriter();
            xw = new XmlTextWriter(sw);
            serbyte.Serialize(xw, ByteTest);
            sr = new StringReader(sw.ToString ());
            serbyte.Deserialize(sr);
            sr.Close();
            xw.Close();
            sw.Dispose();
            sr.Dispose();

            sw = new StringWriter();
            xw = new XmlTextWriter(sw);
            serbool.Serialize(xw, bTest);
            sr = new StringReader(sw.ToString());
            serbool.Deserialize(sr);
            sr.Close();
            xw.Close();
            sw.Dispose();
            sr.Dispose();

            sw = new StringWriter();
            xw = new XmlTextWriter(sw);
            serbytes.Serialize(xw, bytesTest);
            sr = new StringReader(sw.ToString());
            serbytes.Deserialize(sr);
            sr.Close();
            xw.Close();
            sw.Dispose();
            sr.Dispose();

            sw = new StringWriter();
            xw = new XmlTextWriter(sw);
            sersingle.Serialize(xw, singleTest);
            sr = new StringReader(sw.ToString());
            sersingle.Deserialize(sr);
            sr.Close();
            xw.Close();
            sw.Dispose ();
            sr.Dispose();

            string xmlt = "<?xml version=\"1.0\" encoding=\"utf-16\"?><Hackers><Hacker>V. Varadhan</Hacker><Hacker>A.Nagappan</Hacker></Hackers>";

            StringReader sr1 = new StringReader(xmlt);
            XmlTextReader xr1 = new XmlTextReader(sr1);
            xmlTest = new SqlXml(xr1);
            sw = new StringWriter();
            xw = new XmlTextWriter(sw);
            serxml.Serialize(xw, xmlTest);
            sr = new StringReader(sw.ToString());
            SqlXml xmltest1 = (SqlXml) serxml.Deserialize(sr);
            sr.Close();
            xw.Close();
            sw.Dispose();
            sr.Dispose();

        }
    }
}