rendered paste bodyusing 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();
}
}
}