/// <summary> /// Export SQL Script to delete orphan record /// </summary> /// <param name="database"></param> /// <param name="filePath"></param> public static void ExportScriptToDeleteOrphan(MapDatabase database, string filePath) { // // Initialize StreamWriter writer = null; try { writer = new StreamWriter(filePath); } catch (Exception excCreateStream) { LogService.Log.Error("Can not create stream writer at " + filePath, excCreateStream); return; } // // Write out string databaseName = database.GetDatabaseName(); writer.WriteLine("USE [" + database.GetDatabaseName() + "]"); writer.WriteLine("GO"); foreach (ErrorRecord error in _listErrorRecords) { if (error.Type == ErrorType.Orphan) { string script = GenerateDeleteScript(database, databaseName, error); writer.WriteLine(script); writer.WriteLine("GO"); } } // // Clean writer.Close(); }