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; }