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); }