Esempio n. 1
0
        /// <summary>
        /// Writes the specific sequence option and value to the output
        /// </summary>
        /// <param name="option"></param>
        /// <param name="value"></param>
        public override void WriteSequenceOption(DBSequenceBuilderOption option, int value)
        {
            switch (option)
            {
            case DBSequenceBuilderOption.Minimum:
                this.WriteRawSQLString(" MINVALUE ");
                this.Write(value);
                break;

            case DBSequenceBuilderOption.Maximim:
                this.WriteRawSQLString(" MAXVALUE ");
                this.Write(value);
                break;

            case DBSequenceBuilderOption.StartValue:
                this.WriteRawSQLString(" START WITH ");
                this.Write(value);
                break;

            case DBSequenceBuilderOption.Cycling:
                this.WriteRawSQLString(" CYCLE");
                break;

            case DBSequenceBuilderOption.NoCycling:
                this.WriteRawSQLString(" NOCYCLE");
                break;

            case DBSequenceBuilderOption.Ordered:
                this.WriteRawSQLString(" ORDER");
                break;

            case DBSequenceBuilderOption.NotOrdered:
                this.WriteRawSQLString(" NOORDER");
                break;

            case DBSequenceBuilderOption.Increment:
                this.WriteRawSQLString(" INCREMENT BY ");
                this.Write(value);
                break;

            case DBSequenceBuilderOption.Cache:
                this.WriteRawSQLString(" CACHE ");
                this.Write(value);
                break;

            case DBSequenceBuilderOption.NoCaching:
                this.WriteRawSQLString(" NOCACHE");
                break;

            default:
                break;
            }
        }
Esempio n. 2
0
 /// <summary>
 /// Writes the specific sequence option to the output
 /// </summary>
 /// <param name="option"></param>
 public override void WriteSequenceOption(DBSequenceBuilderOption option)
 {
     this.WriteSequenceOption(option, 0);
 }