/// <summary> /// Build 'DELETE' command. /// </summary> /// <param name="command">The 'DELETE' command.</param> /// <returns>The DbCommand.</returns> public DbCommand BuildDeleteCommand(APSqlDeleteCommand command) { if (command == null) throw new ArgumentNullException("command"); return ParseDelete(command); }
/// <summary> /// SQL 'FROM' clause extensions. /// </summary> /// <param name="command">The command.</param> /// <param name="phrases">The 'FROM' phrases.</param> /// <returns>The command.</returns> public static APSqlDeleteCommand from(this APSqlDeleteCommand command, params APSqlFromPhrase[] phrases) { if (phrases != null && phrases.Length != 0) { command.FromClause = new APSqlFromClause(phrases); } return(command); }
/// <summary> /// SQL 'FROM' clause extensions. /// </summary> /// <param name="command">The command.</param> /// <param name="phrases">The 'FROM' phrases.</param> /// <returns>The command.</returns> public static APSqlDeleteCommand from(this APSqlDeleteCommand command, IEnumerable <APSqlFromPhrase> phrases) { if (phrases != null) { command.FromClause = new APSqlFromClause(phrases); } return(command); }
/// <summary> /// Build 'DELETE' command. /// </summary> /// <param name="command">The 'DELETE' command.</param> /// <returns>The DbCommand.</returns> public DbCommand BuildDeleteCommand(APSqlDeleteCommand command) { if (command == null) { throw new ArgumentNullException("command"); } return(ParseDelete(command)); }
/// <summary> /// SQL 'WHERE' phrase extensions. /// </summary> /// <param name="command">The command.</param> /// <param name="joinType">Join type.</param> /// <param name="phrases">The 'WHERE' phrases.</param> /// <returns>The command.</returns> public static APSqlDeleteCommand where (this APSqlDeleteCommand command, APSqlConditionJoinType joinType, params APSqlWherePhrase[] phrases) { if (phrases != null && phrases.Length != 0) { command.WhereClause = new APSqlWhereClause(joinType, phrases); } else { command.WhereClause = null; } return(command); }
/// <summary> /// SQL 'WHERE' phrase extensions. /// </summary> /// <param name="command">The command.</param> /// <param name="joinType">Join type.</param> /// <param name="phrases">The 'WHERE' phrases.</param> /// <returns>The command.</returns> public static APSqlDeleteCommand where (this APSqlDeleteCommand command, APSqlConditionJoinType joinType, IEnumerable <APSqlWherePhrase> phrases) { if (phrases != null) { command.WhereClause = new APSqlWhereClause(joinType, phrases); } else { command.WhereClause = null; } return(command); }
/// <summary> /// SQL 'FROM' clause extensions. Add new 'FROM' in clause. /// </summary> /// <param name="command">The command.</param> /// <param name="phrases">The 'FROM' phrases.</param> /// <returns>The command.</returns> public static APSqlDeleteCommand from_add(this APSqlDeleteCommand command, params APSqlFromPhrase[] phrases) { if (command.FromClause == null || command.FromClause.Next == null) { command.FromClause = new APSqlFromClause(phrases); } else { APSqlFromPhrase exist = command.FromClause.Last as APSqlFromPhrase; exist.SetNext(phrases); } return(command); }
protected override DbCommand ParseDelete(APSqlDeleteCommand command) { StringBuilder sb = new StringBuilder(); OracleCommand dbCmd = new OracleCommand(); using (ParserWriter writer = new ParserWriter(sb, command.CommandNameSuitable)) { WriteDelete(writer, command); writer.Idented++; WriteFrom(writer, command.FromClause, dbCmd); WriteWhere(writer, command.WhereClause, dbCmd); } dbCmd.CommandText = sb.ToString(); return(dbCmd); }
/// <summary> /// SQL 'WHERE' phrase extensions. Add new condition join 'OR' with exist condition. /// </summary> /// <param name="command">The command.</param> /// <param name="phrase">The new 'WHERE' phrase.</param> /// <returns>The command.</returns> public static APSqlDeleteCommand where_or(this APSqlDeleteCommand command, APSqlWherePhrase phrase) { if (command.WhereClause == null || command.WhereClause.Next == null) { command.WhereClause = new APSqlWhereClause(phrase); } else { APSqlWherePhrase exist = command.WhereClause.Next as APSqlWherePhrase; if (exist is APSqlConditionOrPhrase) { (exist as APSqlConditionOrPhrase).Child.Last.SetNext(phrase); } else { command.WhereClause = new APSqlWhereClause(APSqlConditionJoinType.OR, exist, phrase); } } return(command); }
/// <summary> /// SQL 'FROM' clause extensions. /// </summary> /// <param name="command">The command.</param> /// <param name="clause">The 'FROM' clause.</param> /// <returns>The command.</returns> public static APSqlDeleteCommand from(this APSqlDeleteCommand command, APSqlFromClause clause) { command.FromClause = clause; return(command); }
/// <summary> /// Parse 'DELETE' command. /// </summary> /// <param name="command">The 'DELETE' command.</param> /// <returns>The DbCommand.</returns> protected abstract DbCommand ParseDelete(APSqlDeleteCommand command);
private void WriteDelete(ParserWriter writer, APSqlDeleteCommand command) { writer.WriteDirect("DELETE FROM"); writer.Write(command.TableDef.TableName); }
protected override DbCommand ParseDelete(APSqlDeleteCommand command) { StringBuilder sb = new StringBuilder(); SqlCommand dbCmd = new SqlCommand(); using (ParserWriter writer = new ParserWriter(sb, command.CommandNameSuitable)) { WriteDelete(writer, command); writer.Idented++; WriteFrom(writer, command.FromClause, dbCmd); WriteWhere(writer, command.WhereClause, dbCmd); } dbCmd.CommandText = sb.ToString(); return dbCmd; }
/// <summary> /// Execute. /// </summary> /// <param name="command">The command.</param> /// <param name="db">The database.</param> public static void execute(this APSqlDeleteCommand command, APDatabase db) { db.ExecuteNonQuery(command); }
/// <summary> /// SQL 'FROM' clause extensions. /// </summary> /// <param name="command">The command.</param> /// <param name="phrase">The 'FROM' phrase.</param> /// <returns>The command.</returns> public static APSqlDeleteCommand from(this APSqlDeleteCommand command, APSqlFromPhrase phrase) { command.FromClause = new APSqlFromClause(phrase); return(command); }
/// <summary> /// Build 'DELETE' command. /// </summary> /// <param name="command">The 'DELETE' command.</param> /// <returns>The DbCommand.</returns> public abstract DbCommand BuildDeleteCommand(APSqlDeleteCommand command);
/// <summary> /// Build 'DELETE' command. /// </summary> /// <param name="command">The 'DELETE' command.</param> /// <returns>The DbCommand.</returns> public override DbCommand BuildDeleteCommand(APSqlDeleteCommand command) { return(_parser.BuildDeleteCommand(command)); }
/// <summary> /// SQL 'WHERE' phrase extensions. /// </summary> /// <param name="command">The command.</param> /// <param name="phrase">The 'WHERE' phrase.</param> /// <returns>The command.</returns> public static APSqlDeleteCommand where (this APSqlDeleteCommand command, APSqlWherePhrase phrase) { command.WhereClause = new APSqlWhereClause(phrase); return(command); }
/// <summary> /// SQL 'WHERE' clause extensions. /// </summary> /// <param name="command">The command.</param> /// <param name="clause">The 'WHERE' clause.</param> /// <returns>The command.</returns> public static APSqlDeleteCommand where (this APSqlDeleteCommand command, APSqlWhereClause clause) { command.WhereClause = clause; return(command); }
private void WriteDelete(ParserWriter writer, APSqlDeleteCommand command) { writer.WriteDirect("DELETE FROM"); writer.Write(command.TableDef.TableName); }
/// <summary> /// Parse 'DELETE' command. /// </summary> /// <param name="command">The 'DELETE' command.</param> /// <returns>The DbCommand.</returns> protected abstract DbCommand ParseDelete(APSqlDeleteCommand command);
/// <summary> /// Build 'DELETE' command. /// </summary> /// <param name="command">The 'DELETE' command.</param> /// <returns>The DbCommand.</returns> public override DbCommand BuildDeleteCommand(APSqlDeleteCommand command) { return _parser.BuildDeleteCommand(command); }
/// <summary> /// Build 'DELETE' command. /// </summary> /// <param name="command">The 'DELETE' command.</param> /// <returns>The DbCommand.</returns> public abstract DbCommand BuildDeleteCommand(APSqlDeleteCommand command);