C# (CSharp) AdminQuery.DropFunction Exemples

Exemple #1

        public void Existing()
        {
            var funcName = ObjectName.Parse("APP.func1");

            AdminQuery.DropFunction(funcName);

            var exists = AdminQuery.Access().ObjectExists(DbObjectType.Routine, funcName);

            Assert.IsFalse(exists);
        }

Exemple #2

        public void NotExisting_IfExistsClause()
        {
            var funcName = ObjectName.Parse("APP.func2");

            Assert.DoesNotThrow(() => AdminQuery.DropFunction(funcName, true));
        }

Exemple #3

        public void NotExisting()
        {
            var funcName = ObjectName.Parse("APP.func2");

            Assert.Throws <ObjectNotFoundException>(() => AdminQuery.DropFunction(funcName));
        }