public virtual DbGenerateTableStatement CreateGenerateTableClause()
{
DbGenerateTableStatement statement = new DbGenerateTableStatement();
statement.DbMgr = this;
return(statement);
}
public override DbCommand CreateDbCommand(DbGenerateTableStatement _query)
{
DB2Command command = ((DB2Connection)DbConnection).CreateCommand();
command.CommandText = _query.ToString();
return(command);
}
public override DbCommand CreateDbCommand(DbGenerateTableStatement clause)
{
OracleCommand command = ((OracleConnection)DbConnection).CreateCommand();
command.CommandText = clause.ToString();
return(command);
}
public virtual int ExecuteNonQuery(DbGenerateTableStatement clause)
{
int result = 0;
DbCommand _cmd = CreateDbCommand(clause);
result = _cmd.ExecuteNonQuery();
_cmd.Dispose();
return(result);
}
public override int ExecuteNonQuery(DbGenerateTableStatement clause)
{
string sequence_name = string.Format("{0}Seq", clause.Tablename);
sequence_name = FieldAlias(sequence_name);
bool sequence_found = IsSequenceFound(sequence_name);
if (sequence_found == false)
{
CreateSequence(sequence_name);
}
//Log(clause.ToString());
int result = 0;
DbCommand _cmd = CreateDbCommand(clause);
result = _cmd.ExecuteNonQuery();
_cmd.Dispose();
return(result);
}
public override DbCommand CreateDbCommand(DbGenerateTableStatement _query)
{
return(new OleDbCommand(_query.ToString(), (OleDbConnection)DbConnection));
}
public abstract DbCommand CreateDbCommand(DbGenerateTableStatement clause);
