public override DbCommand CreateDbCommand(DbUpdateStatement _query) { DB2Command command = ((DB2Connection)DbConnection).CreateCommand(); command.CommandText = _query.ToString(); return(command); }
public override DbCommand CreateDbCommand(DbUpdateStatement clause) { OracleCommand command = ((OracleConnection)DbConnection).CreateCommand(); command.CommandText = clause.ToString(); return(command); }
public int ExecuteNonQuery(DbUpdateStatement clause) { int result = 0; DbCommand _cmd = CreateDbCommand(clause); result = _cmd.ExecuteNonQuery(); _cmd.Dispose(); return(result); }
private DbUpdateStatement GetQuery_UpdateQuery(SaleLine _obj) { DbUpdateStatement clause = DbMgr.CreateUpdateClause(); clause .UpdateColumns(GetFields(_obj)) .From("SaleLines") .Criteria .IsEqual("SaleLines", "SaleLineID", _obj.SaleLineID); return(clause); }
private DbUpdateStatement GetQuery_UpdateQuery(Currency _obj) { DbUpdateStatement clause = DbMgr.CreateUpdateClause(); clause .UpdateColumns(GetFields(_obj)) .From("Currency") .Criteria.IsEqual("Currency", "CurrencyID", _obj.CurrencyID); return(clause); }
public virtual DbUpdateStatement CreateUpdateClause(string table, Dictionary <string, DbFieldEntry> fields, string fieldname, string fieldvalue) { DbUpdateStatement clause = CreateUpdateClause(); clause .UpdateColumns(fields) .From(table) .Criteria .IsEqual(table, fieldname, fieldvalue); return(clause); }
public virtual DbUpdateStatement CreateUpdateClause(string table, Dictionary <string, DbFieldEntry> fields, string fieldname, int?fieldvalue) { if (fieldvalue == null) { StringBuilder sb = new StringBuilder(); foreach (string key in fields.Keys) { sb.AppendFormat("\r\n{0}: {1}", key, fields[key]); } throw new NullReferenceException(string.Format("{0} cannot be null before update:\r\n{1}", fieldname, sb.ToString())); } DbUpdateStatement clause = CreateUpdateClause(); clause .UpdateColumns(fields) .From(table) .Criteria .IsEqual(table, fieldname, fieldvalue); return(clause); }
public override DbCommand CreateDbCommand(DbUpdateStatement _query) { return(new OleDbCommand(_query.ToString(), (OleDbConnection)DbConnection)); }
public abstract DbCommand CreateDbCommand(DbUpdateStatement clause);
public virtual DbUpdateStatement CreateUpdateClause() { DbUpdateStatement clause = new DbUpdateStatement(this); return(clause); }
public int ExecuteNonQuery(DbUpdateStatement clause) { return(DbMgr.ExecuteNonQuery(clause)); }
protected DbCommand CreateDbCommand(DbUpdateStatement clause) { return(DbMgr.CreateDbCommand(clause)); }