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