How to use ExternalDependencyNotFoundException class of NBi.Extensibility package

Best NBi code snippet using NBi.Extensibility.ExternalDependencyNotFoundException

ExternalFileQueryResolverTest.cs

Source:ExternalFileQueryResolverTest.cs

...63                new List<IQueryParameter>() { new QueryParameter("param", "10") },64                new List<IQueryTemplateVariable>() { new QueryTemplateVariableXml() { Name = "operator", Value = "not in" } },65                new TimeSpan(0, 0, 10));66            var resolver = new ExternalFileQueryResolver(args);67            Assert.Throws<ExternalDependencyNotFoundException>(() => resolver.Execute());68        }69        [Test]70        public void Execute_InvalidPath_MessageRelativePath()71        {72            var args = new ExternalFileQueryResolverArgs(73                @"NotExistingFile.sql",74                ConnectionStringReader.GetSqlClient(),75                new List<IQueryParameter>() { new QueryParameter("param", "10") },76                new List<IQueryTemplateVariable>() { new QueryTemplateVariableXml() { Name = "operator", Value = "not in" } },77                new TimeSpan(0, 0, 10));78            var resolver = new ExternalFileQueryResolver(args);79            var ex = Assert.Catch<ExternalDependencyNotFoundException>(() => resolver.Execute());80            Assert.That(ex.Message, Does.Contain(@"NBi.Testing\bin\"));81            Assert.That(ex.Message, Does.Contain(@"NotExistingFile.sql"));82        }83        [Test]84        public void Execute_InvalidAbsolutePath_MessageAbsolutePath()85        {86            var args = new ExternalFileQueryResolverArgs(87                @"C:\NotExistingFile.sql",88                ConnectionStringReader.GetSqlClient(),89                new List<IQueryParameter>() { new QueryParameter("param", "10") },90                new List<IQueryTemplateVariable>() { new QueryTemplateVariableXml() { Name = "operator", Value = "not in" } },91                new TimeSpan(0, 0, 10));92            var resolver = new ExternalFileQueryResolver(args);93            var ex = Assert.Catch<ExternalDependencyNotFoundException>(() => resolver.Execute());94            Assert.That(ex.Message, Does.Contain(@"C:\NotExistingFile.sql"));95        }96    }97}...

BatchRunnerSmo.cs

Source:BatchRunnerSmo.cs

...22        }23        public void Execute()24        {25            if (!File.Exists(fullPath))26                throw new ExternalDependencyNotFoundException(fullPath);27            var script = File.ReadAllText(fullPath);28            Trace.WriteLineIf(Extensibility.NBiTraceSwitch.TraceVerbose, script);29            var server = new Server();30            server.ConnectionContext.ConnectionString = connectionString;31            server.ConnectionContext.ExecuteNonQuery(script);32        }33    }34}

ExternalDependencyNotFoundException.cs

Source:ExternalDependencyNotFoundException.cs

...4using System.Linq;5using System.Text;6namespace NBi.Extensibility7{8    public class ExternalDependencyNotFoundException : NBiException9    {10        public ExternalDependencyNotFoundException(string filename) 11            : base ($"This test is in error because the following dependency has not been found '{Path.GetFullPath(filename)}'.")12        { }13    }14}...