public static int NextSequenceValue(string sequence) { try { return(Convert.ToInt32(SqlText.ExecuteScalar(String.Format("select {0}.nextval from dual", sequence)))); } catch (Exception) { return(0); } }
public static object[] Execute(string text, params System.Object[] args) { using (SqlText sel = Create(text, args)) if (sel.Read()) { object[] result = new object[sel.Reader.FieldCount]; sel.Reader.GetValues(result); return(result); } else { return(null); } }
public static SqlText Create(string text, params System.Object[] args) { SqlText sel = new SqlText(text); Match m = Regex.Match(text, String.Format("({0}\\w+)", sel.ParameterMarker)); int parameterIndex = 0; while (m.Success) { sel.AddParameter(m.Value, args[parameterIndex]); parameterIndex++; m = m.NextMatch(); } return(sel); }
public static int ExecuteNonQuery(string text, params System.Object[] args) { using (SqlText sel = Create(text, args)) return(sel.ExecuteNonQuery()); }
public static object ExecuteScalar(string text, params System.Object[] args) { using (SqlText sel = Create(text, args)) return(sel.ExecuteScalar()); }