public override DataSet ExecuteToDataSet(string sComando, EnumExecutionType execution)
{
this.oCommand.CommandText = sComando;
this.oCommand.CommandType = this.ConvertToCommandType(execution);
try
{
this.Open();
this.oAdapter = new SQLiteDataAdapter(this.oCommand);
this.oDataSetReturn = new DataSet();
this.oAdapter.Fill(this.oDataSetReturn);
return(this.oDataSetReturn);
}
catch (Exception)
{
throw;
}
finally
{
this.Close();
}
}
protected CommandType ConvertToCommandType(EnumExecutionType execution)
{
if (execution == EnumExecutionType.Text)
{
return(CommandType.Text);
}
else if (execution == EnumExecutionType.StoredProcedure)
{
return(CommandType.StoredProcedure);
}
else if (execution == EnumExecutionType.TableDirect)
{
return(CommandType.TableDirect);
}
else
{
return(CommandType.Text);
}
}
public override int Execute(string sComando, EnumExecutionType execution)
{
this.oCommand.CommandText = sComando;
this.oCommand.CommandType = this.ConvertToCommandType(execution);
try
{
this.Open();
return(this.oCommand.ExecuteNonQuery());
}
catch (Exception)
{
throw;
}
finally
{
this.Close();
}
}
public abstract DataTable ExecuteToDataTable(string sComando, EnumExecutionType execution);
public abstract DataSet ExecuteToDataSet(string sComando, EnumExecutionType execution);
public abstract int Execute(string sComando, EnumExecutionType execution);
public DaSessionWrite()
{
ValidateAllResults = true;
ExecutionType = EnumExecutionType.SYNCHRONOUS;
}
public DaSubscriptionRead()
{
ExecutionType = EnumExecutionType.SYNCHRONOUS;
}
public DaSessionRead()
{
ExecutionType = EnumExecutionType.SYNCHRONOUS;
}
