protected virtual string GetStatementSql(DeleteStatement statement)
{
StringBuilder sb = new StringBuilder();
sb.Append("DELETE ");
sb.Append(GetSql(statement.From));
if (statement.Where != null)
{
sb.Append(GetSql(statement.Where));
sb.Append(' ');
sb.Append(Environment.NewLine);
}
sb.Append(';');
return(sb.ToString());
}
protected void OnEmptyTable ()
{
TableNode node = (TableNode)CurrentNode.DataItem;
if (Services.MessageService.AskQuestion (
GettextCatalog.GetString ("Are you sure you want to empty table '{0}'", node.Table.Name),
GettextCatalog.GetString ("Empty Table")
)) {
IdentifierExpression tableId = new IdentifierExpression (node.Table.Name);
DeleteStatement del = new DeleteStatement (new FromTableClause (tableId));
IPooledDbConnection conn = node.ConnectionContext.ConnectionPool.Request ();
IDbCommand command = conn.CreateCommand (del);
conn.ExecuteNonQueryAsync (command, new ExecuteCallback<int> (OnEmptyTableCallback), null);
}
}
protected virtual string GetStatementSql (DeleteStatement statement)
{
StringBuilder sb = new StringBuilder ();
sb.Append ("DELETE ");
sb.Append (GetSql (statement.From));
if (statement.Where != null) {
sb.Append (GetSql (statement.Where));
sb.Append (' ');
sb.Append (Environment.NewLine);
}
sb.Append (';');
return sb.ToString ();
}
