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