public void ScriptObject(StoredProcedure storedProcedure, Options options)
        {
            StringCollection script   = storedProcedure.Script(_scriptingOptions);
            string           path     = _directoryService.GetStoredProceduresDirectory(options.Root);
            string           fileName = Path.Combine(path, string.Concat(storedProcedure.Name, ".sql"));

            _fileWriter.WriteFile(fileName, script.Cast <string>());
        }
        public void CreateStoredProcedures(Options options)
        {
            string directory = _directoryService.GetStoredProceduresDirectory(options.Root);

            if (!Directory.Exists(directory))
            {
                Console.WriteLine($"Stored procedures directory '{directory}' does not exist");
                return;
            }

            IEnumerable <string> files = Directory.GetFiles(directory);

            ProcessDirectoryFiles(files, options);
        }