public void GetDefinitionUsingDeclarationItemWithoutConnectionTest()
        {
            PeekDefinition   peekDefinition = new PeekDefinition(null, null);
            string           objectName     = "tableName";
            string           fullObjectName = "master.dbo.tableName";
            DefinitionResult result         = peekDefinition.GetDefinitionUsingDeclarationType(DeclarationType.Table, fullObjectName, objectName, null);

            Assert.NotNull(result);
            Assert.True(result.IsErrorResult);
        }
示例#2
0
        public void GetDefinitionUsingDeclarationTypeWithNonexistentObjectTest()
        {
            ConnectionInfo   connInfo         = TestObjects.InitLiveConnectionInfoForDefinition();
            ServerConnection serverConnection = TestObjects.InitLiveServerConnectionForDefinition(connInfo);

            PeekDefinition peekDefinition = new PeekDefinition(serverConnection, connInfo);
            string         objectName     = "doesNotExist";
            string         schemaName     = "sys";

            DefinitionResult result = peekDefinition.GetDefinitionUsingDeclarationType(DeclarationType.View, "master.sys.objects", objectName, schemaName);

            Assert.NotNull(result);
            Assert.True(result.IsErrorResult);
        }
示例#3
0
        public async Task GetUnsupportedDefinitionErrorTest()
        {
            ConnectionInfo   connInfo         = TestObjects.InitLiveConnectionInfoForDefinition();
            ServerConnection serverConnection = TestObjects.InitLiveServerConnectionForDefinition(connInfo);

            PeekDefinition peekDefinition = new PeekDefinition(serverConnection, connInfo);
            string         objectName     = "objects";
            string         schemaName     = "sys";
            // When I try to get definition for 'Collation'
            DefinitionResult result = peekDefinition.GetDefinitionUsingDeclarationType(DeclarationType.Collation, "master.sys.objects", objectName, schemaName);

            // Then I expect non null result with error flag set
            Assert.NotNull(result);
            Assert.True(result.IsErrorResult);
        }