protected virtual void WriteScript(string objectName, ExportObjectType objectType, string sql) { Throw.If(objectName).IsEmpty(); if (sql != null) { sql = sql.Trim(); } // write sproc to file string dir = Path.Combine(exportDirectory, objectType.ToString()); string scriptPath = Path.Combine(dir, objectName + ".sql"); if (!string.IsNullOrEmpty(sql)) { try { if (!Directory.Exists(dir)) { Directory.CreateDirectory(dir); } if (File.Exists(scriptPath)) { File.SetAttributes(scriptPath, FileAttributes.Normal); } using (StreamWriter scriptFile = new StreamWriter(scriptPath, false)) { scriptFile.Write(sql); } } catch (Exception ex) { string msg = string.Format("Could not write the script file {0} to disk.", scriptPath); throw new SqlExporterException(msg, ex); } OnScriptWrittenEvent(new ScriptWrittenEventArgs(scriptPath)); } }
protected virtual void WriteScript(string objectName, ExportObjectType objectType, string sql) { Throw.If(objectName).IsEmpty(); if (sql != null) sql = sql.Trim(); // write sproc to file string scriptPath = Path.Combine(_exportDirectory, _dbName + ".sql"); if (!string.IsNullOrEmpty(sql)) { try { if (!Directory.Exists(_exportDirectory)) Directory.CreateDirectory(_exportDirectory); if (File.Exists(scriptPath)) File.SetAttributes(scriptPath, FileAttributes.Normal); using (StreamWriter scriptFile = new StreamWriter(scriptPath, true)) { scriptFile.Write(sql); scriptFile.WriteLine(); scriptFile.WriteLine(); scriptFile.WriteLine("-------------------------------------------------------------------"); scriptFile.WriteLine(); } } catch (Exception ex) { string msg = string.Format("Could not write the script file {0} to disk.", scriptPath); throw new SqlExporterException(msg, ex); } OnScriptWrittenEvent(new ScriptWrittenEventArgs(scriptPath)); } }