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