/// <summary>
/// Generate SQL script to delete this record
/// </summary>
/// <param name="database"></param>
protected static string GenerateDeleteScript(MapDatabase database, string databaseName, ErrorRecord error)
{
//
// Initialize result
string result = "";
string TEMPLATE = "DELETE FROM {DATABASE_NAME}.dbo.{TABLE_NAME} WHERE {PRIMARY_KEY_CONDITION}";
string DATABASE_NAME = databaseName;
string TABLE_NAME = error.TableName;
string PRIMARY_KEY_CONDITION = "";
//
// Get neccessary information
bool firstPrimaryKey = true;
Dictionary <string, object> primaryKeys = database.GetPrimaryKeyValue(error.TableName, error.Record);
foreach (string primaryKey in primaryKeys.Keys)
{
//
// Get primary key value as string
object objPrimaryKeyValue = primaryKeys[primaryKey];
string strPrimaryKeyValue = "";
if (objPrimaryKeyValue is string)
{
strPrimaryKeyValue = "'" + objPrimaryKeyValue + "'";
}
else
{
strPrimaryKeyValue = objPrimaryKeyValue.ToString();
}
//
// Add to PRIMARY_KEY_CONDITION
if (firstPrimaryKey)
{
firstPrimaryKey = false;
PRIMARY_KEY_CONDITION = primaryKey + " = " + strPrimaryKeyValue;
}
else
{
PRIMARY_KEY_CONDITION = PRIMARY_KEY_CONDITION + ", " + primaryKey + " = " + strPrimaryKeyValue;
}
}
//
// Return result
result = TEMPLATE.Replace("{DATABASE_NAME}", DATABASE_NAME)
.Replace("{TABLE_NAME}", TABLE_NAME)
.Replace("{PRIMARY_KEY_CONDITION}", PRIMARY_KEY_CONDITION);
return(result);
}