public void CreateTest1()
{
ServerConnection conn = new ServerConnection("vish-laptop\\sqlexpress2008");
target = new SQL2008Server(conn);
Assert.IsNotNull(target, "Failed to create SQL2008Server");
}
public void CreateTest()
{
string connStr = @"Data Source=vish-laptop\sqlexpress2008;Initial Catalog=VishDB;Integrated Security=True;Connection Timeout=180;";
SqlConnection conn = new SqlConnection(connStr);
target = new SQL2008Server(conn);
Assert.IsNotNull(target, "Failed to create SQL2008Server");
}
public void CreateTest1(string serverName, string databaseName)
{
ServerConnection conn = new ServerConnection(serverName);
SQL2008Server server = new SQL2008Server(conn);
target = new SQL2008Database(server, databaseName);
Assert.IsNotNull(target, "Failed to create SQL2008Database");
target.Dispose();
}
public void ContainsDatabaseTest(string serverName, string databaseName)
{
ServerConnection conn = new ServerConnection(serverName);
target = new SQL2008Server(conn);
Assert.IsNotNull(target, "Failed to create SQL2008Server");
Assert.AreEqual(true, target.ContainsDatabase(databaseName), "Failed to find VishDB database");
Assert.AreEqual(false, target.ContainsDatabase("ThisDBdoesNotExist"), "Failed to find VishDB database");
}
public void CreateDeleteTableTest(string serverName, string databaseName, string tableName)
{
ServerConnection conn = new ServerConnection(serverName);
SQL2008Server server = new SQL2008Server(conn);
target = new SQL2008Database(server, databaseName);
Assert.IsNotNull(target, "Failed to create SQL2008Database");
target.CreateTable(tableName, new List <DataColumn>()
{
new DataColumn("ID", typeof(int))
}.GetEnumerator());
target.DeleteTable(tableName);
target.Dispose();
}
public void CreateGeographyfromGISFieldsTest(string serverName, string databaseName, string tableName, string geometryFieldName)
{
DataColumn dc1 = new DataColumn("ID", typeof(int));
DataColumn dc2 = new DataColumn("SHAPE", typeof(SqlGeography));
DataColumn[] list = new DataColumn[] { dc1, dc2 };
SQL2008GISFields gisFields = new SQL2008GISFields(list);
ServerConnection conn = new ServerConnection(serverName);
SQL2008Server server = new SQL2008Server(conn);
target = new SQL2008Database(server, databaseName);
target.CreateGeographyTable(gisFields, tableName, geometryFieldName);
target.DeleteTable(tableName);
}
public void ContainsTableTest(string serverName, string databaseName, string tableName)
{
ServerConnection conn = new ServerConnection(serverName);
SQL2008Server server = new SQL2008Server(conn);
target = new SQL2008Database(server, databaseName);
Assert.IsNotNull(target, "Failed to create SQL2008Database");
target.CreateTable(tableName, new List <DataColumn>()
{
new DataColumn("ID", typeof(int))
}.GetEnumerator());
Assert.AreEqual(true, target.ContainsTable(tableName), "Unable to find table '" + tableName + "' in the database '" + databaseName + "'.");
target.DeleteTable(tableName);
target.Dispose();
}
