コード例 #1
0
        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();
        }
コード例 #2
0
        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();
        }