public SqlTables()
{
conn = new SqlConnection();
conn.ConnectionString = "get your connection string"; // Default ConnectionString (First)
cmd = new SqlCommand();
cmd.Connection = conn;
_res = new Returened();
_returnedValues = new DbReturned <T>();
}
public SqlTables(string connectionString)
{
conn = new SqlConnection();
conn.ConnectionString = connectionString;
cmd = new SqlCommand();
cmd.Connection = conn;
_res = new Returened();
_returnedValues = new DbReturned <T>();
}
public OracleTables()
{
conn = new OracleConnection();
conn.ConnectionString = "";//Connections.ConnectionString(1); // Default ConnectionString (First)
cmd = new OracleCommand();
cmd.Connection = conn;
_res = new Returened();
_returnedValues = new DbReturned <T>();
}
/// <summary>
/// Set Error and State Information for methods
/// </summary>
/// <param name="exp"></param>
/// <param name="RowID"></param>
/// <returns></returns>
public DbReturned <T> SetException(Exception exp, Int32 RowID)
{
// Set Parameters
DbReturned <T> res = new DbReturned <T>();
_returnedState.State = false;
_returnedValues.RowEffected = 0;
_returnedState.ErrorMessage = exp.Message;
_returnedState.RowID = RowID;
_returnedValues.Exp = exp;
res.Returened = _returnedState;
return(res);
}
