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