public void SetQueueSequenceValue(long value) { var connection = Database.GetDbConnection(); connection.Open(); using (var cmd = connection.CreateCommand()) { cmd.CommandText = PostgressSql.SetQueueSequenceVal(value); var obj = cmd.ExecuteScalar(); } connection.Close(); }
// TODO refactor sequence part public long GetNextQueueSequenceValue() { var connection = Database.GetDbConnection(); connection.Open(); long result = 0; using (var cmd = connection.CreateCommand()) { cmd.CommandText = PostgressSql.GetQueueSequenceVal(); var obj = cmd.ExecuteScalar(); result = (long)obj; } connection.Close(); return(result); }