public void Setup()
{
UnitTestStartAndEnd.Start(DatabaseName);
var customObject = new CustomObject()
{
IntegerField = 42,
StringField = "The answer to everything..."
};
var customXml = string.Empty;
var stringBuilder = new StringBuilder();
using (var writer = XmlWriter.Create(stringBuilder, new XmlWriterSettings()
{
OmitXmlDeclaration = true
}))
{
XmlSerializerNamespaces ns = new XmlSerializerNamespaces();
ns.Add(string.Empty, string.Empty);
new XmlSerializer(typeof(CustomObject)).Serialize(writer, customObject, ns);
customXml = stringBuilder.ToString();
}
ExecuteNonQuery("CREATE Table TestObject (id int not null, name varchar(250), location geography, customData xml)");
ExecuteNonQuery("INSERT INTO TestObject (id, name, location, customData) values(1, 'One', geography::STGeomFromText('Point(-122.360 47.656)', 4326), '" + customXml + "')");
ExecuteNonQuery("INSERT INTO TestObject (id, name, location, customData) values(2, 'Two', geography::STGeomFromText('Point(-122.360 47.656)', 4326), '" + customXml + "')");
ExecuteNonQuery("INSERT INTO TestObject (id, name, location, customData) values(3, 'Three', geography::STGeomFromText('Point(-122.360 47.656)', 4326), '" + customXml + "')");
ExecuteNonQuery("INSERT INTO TestObject (id, name, location, customData) values(4, 'Four', geography::STGeomFromText('Point(-122.360 47.656)', 4326), '" + customXml + "')");
ExecuteNonQuery("INSERT INTO TestObject (id, name, location, customData) values(5, 'Five', geography::STGeomFromText('Point(-122.360 47.656)', 4326), '" + customXml + "')");
}
public void TearDown()
{
UnitTestStartAndEnd.End(DatabaseName);
}
