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 int NextGeneratorValue(string generator)
{
try
{
return(Convert.ToInt32(SqlText.ExecuteScalar(String.Format("SELECT NEXT VALUE FOR {0} FROM RDB$DATABASE", generator))));
}
catch (Exception)
{
return(0);
}
}
public static object ExecuteScalar(string text, params System.Object[] args)
{
using (SqlText sel = Create(text, args))
return(sel.ExecuteScalar());
}