public IDataReader ExecuteReader(string sql, Trx trxName) { return(ExecuteReader(sql, null, trxName)); }
//public int GetNextID(string Name) //{ // throw new NotImplementedException(); //} /// <summary> /// Drop Existing if any and create new Sequence. /// </summary> /// <param name="name"></param> /// <param name="increment"></param> /// <param name="minvalue"></param> /// <param name="maxvalue"></param> /// <param name="start"></param> /// <param name="trxName"></param> /// <returns></returns> public bool CreateSequence(string name, int increment, int minvalue, int maxvalue, int start, Trx trxName) { int no = DB.ExecuteQuery("DROP SEQUENCE " + name.ToUpper() + "_SEQ", null, trxName); no = DB.ExecuteQuery("CREATE SEQUENCE " + name.ToUpper() + "_SEQ" + " MINVALUE " + minvalue + " MAXVALUE " + maxvalue + " START WITH " + start + " INCREMENT BY " + increment, null, trxName) ; if (no == -1) { return(false); } else { return(true); } //if (no == -1 && Common.Common.LenghtyTableNames.IndexOf(name.ToUpper()) > -1) //{ // name = name.Substring(0, 25); // DB.ExecuteQuery("DROP SEQUENCE " + name.ToUpper()+ "_SEQ", null, trxName); // no = DB.ExecuteQuery("CREATE SEQUENCE " + name.ToUpper()+ "_SEQ" // + " MINVALUE " + minvalue // + " MAXVALUE " + maxvalue // + " START WITH " + start // + " INCREMENT BY " + increment + " CACHE 20", null, trxName); // if (no == -1) // return false; // else // return true; //} //else // return true; }
public DataSet ExecuteDataset(string sql, Trx trxName) { return(ExecuteDataset(sql, null, trxName)); }