I'd rather play golf

dbinit helloseq.db

CREATE SEQUENCE Employee_sequence INCREMENT BY 10 START WITH 1

CREATE TABLE Employee (
   ID INTEGER NOT NULL PRIMARY KEY DEFAULT (Employee_sequence.NEXTVAL),
   NAME VARCHAR(50) NULL,
   MANAGER INTEGER NULL
)

<?xml version="1.0" encoding="Windows-1252" ?>
<hibernate-mapping xmlns="urn:nhibernate-mapping-2.2" auto-import="true">
  <class name="HelloNHibernate.Employee, HelloNHibernate_sequences" lazy="false">
    <id name="id" access="field">
      <generator class="sequence">
         <param name="sequence">Employee_sequence</param>
	 <param name="parameters">"INCREMENT BY 10 START WITH 1"</param>
      </generator>
    </id>
    <property name="name" access="field" column="name"/>
    <many-to-one access="field" name="manager" column="manager" cascade="all"/>
  </class>
</hibernate-mapping>

<?xml version="1.0" encoding="utf-8" ?>
<configuration>
  <configSections>
    <section name="hibernate-configuration" 
             type="NHibernate.Cfg.ConfigurationSectionHandler, NHibernate" />
    <section name="log4net" 
             type="log4net.Config.Log4NetConfigurationSectionHandler, log4net" />
  </configSections>
  <hibernate-configuration xmlns="urn:nhibernate-configuration-2.2">
    <session-factory>
      <property name="proxyfactory.factory_class">
        NHibernate.ByteCode.LinFu.ProxyFactoryFactory, NHibernate.ByteCode.LinFu
      </property>
      <property name="connection.provider">
        NHibernate.Connection.DriverConnectionProvider
      </property>
      <property name="connection.driver_class">
        NHibernate.Driver.ASA10ClientDriver
      </property>
      <property name="connection.connection_string">
        uid=dba;pwd=sql
      </property>
      <property name="show_sql">true</property>
      <property name="dialect">NHibernate.Dialect.SQLAnywhere12Dialect</property>
    </session-factory>
  </hibernate-configuration>
 
  <log4net>
    <appender name="ConsoleAppender" type="log4net.Appender.ConsoleAppender, log4net">
      <layout type="log4net.Layout.PatternLayout, log4net">
        <param name="ConversionPattern" value="%d %p %m%n" />
      </layout>
    </appender>
    <appender name="RollingFile" type="log4net.Appender.RollingFileAppender,log4net" >
      <param name="File" value="c:\nh210\HelloNHibernate_sequences\log.txt" />
      <param name="AppendToFile" value="true" />
      <param name="DatePattern" value="yyyy.MM.dd" />
      <layout type="log4net.Layout.PatternLayout,log4net">
        <conversionPattern value="%d %p %m%n" />
      </layout>
    </appender>
    <root>
      <priority value="DEBUG" />
      <appender-ref ref="ConsoleAppender" />
    </root>
  </log4net>
</configuration>

NHibernate: SELECT Employee_sequence.NEXTVAL FROM SYS.DUMMY
NHibernate: INSERT INTO Employee (name, manager, id) VALUES (?, ?, ?);p0 = 'Tobin Harris', p1 = NULL, p2 = 41
Saved Tobin to the database
NHibernate: select employee0_.id as id0_, employee0_.name as name0_, employee0_.manager as manager0_ from Employee employee0_ where employee0_.name='Tobin Harris'
NHibernate: SELECT Employee_sequence.NEXTVAL FROM SYS.DUMMY
NHibernate: INSERT INTO Employee (name, manager, id) VALUES (?, ?, ?);p0 = 'Pierre Henri Kuate', p1 = NULL, p2 = 51
NHibernate: UPDATE Employee SET name = ?, manager = ? WHERE id = ?;p0 = 'Tobin David Harris', p1 = 51, p2 = 41
Updated Tobin and added Pierre Henri
NHibernate: select employee0_.id as id0_, employee0_.name as name0_, employee0_.manager as manager0_ from Employee employee0_ order by employee0_.name asc
 
2 employees found:
'Hello World!', said Pierre Henri Kuate.
'Hello World!', said Tobin David Harris.
Press any key to exit...

using System;
using System.Collections;
using System.Data;
using System.Data.Common;
using System.Text.RegularExpressions;
 
using NHibernate.Dialect.Function;
using NHibernate.Dialect.Lock;
using NHibernate.Dialect.Schema;
using NHibernate.Engine;
using NHibernate.Exceptions;
using NHibernate.Mapping;
using NHibernate.SqlCommand;
using NHibernate.Type;
using NHibernate.Util;
 
using Environment = NHibernate.Cfg.Environment;
 
namespace NHibernate.Dialect
{
	/// <summary>
	/// SQL Dialect for SQL Anywhere 12 - for the NHibernate 2.0.1 distribution
	/// Copyright (C) 2010 Glenn Paulley
        /// Contact: http://iablog.sybase.com/paulley
	///
	/// This NHibernate dialect should be considered BETA software.
	///
	/// This library is free software; you can redistribute it and/or
	/// modify it under the terms of the GNU Lesser General Public
	/// License as published by the Free Software Foundation; either
	/// version 2.1 of the License, or (at your option) any later version.
	///
	/// This library is distributed in the hope that it will be useful,
	/// but WITHOUT ANY WARRANTY; without even the implied warranty of
	/// MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU
	/// Lesser General Public License for more details.
	///
	/// You should have received a copy of the GNU Lesser General Public
	/// License along with this library; if not, write to the Free Software
	/// Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA
	///
	/// </summary>
	/// <remarks>
	/// The SQLAnywhere12Dialect uses the SQLAnywhere11Dialect as its base class. 
        /// SQLAnywhere12Dialect includes support for ORACLE-style sequences, defined 
        /// in a new catalog table <tt>SYSSEQUENCE</tt>. 
	/// </remarks>
	public class SQLAnywhere12Dialect : SQLAnywhere11Dialect
	{
		/// <summary></summary>
		public SQLAnywhere12Dialect()
		{
		    RegisterDateTimeTypeMappings();
		    RegisterKeywords();
		}
 
		new protected void RegisterKeywords() 
		{
		    RegisterKeyword( "NEAR" );
		    RegisterKeyword( "LIMIT" );
		    RegisterKeyword( "OFFSET" );
		}
 
		new protected void RegisterDateTimeTypeMappings() 
		{
		    RegisterColumnType(DbType.DateTimeOffset, "DATETIMEOFFSET");
		}
 
 
		// DDL support ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
 
		/// <summary> 
		/// SQL Anywhere supports <tt>SEQUENCES</tt> using a primarily SQL Standard 
	        /// syntax. Sequence values can be queried using the <tt>.CURRVAL</tt> identifier, and the next
	        /// value in a sequence can be retrieved using the <tt>.NEXTVAL</tt> identifier. Sequences
	        /// are retained in the SYS.SYSSEQUENCE catalog table. 
		/// </summary>
		public override bool SupportsSequences
		{
			get { return true; }
		}
 
	        /// <summary>
	        /// Pooled sequences does not refer to the CACHE parameter of the <tt>CREATE SEQUENCE</tt>
	        /// statement, but merely if the DBMS supports sequences that can be incremented or decremented
	        /// by values greater than 1. 
	        /// </summary>
		public override bool SupportsPooledSequences
		{
			get { return true; }
		}
 
		/// <summary> Get the <tt>SELECT</tt> command used retrieve the names of all sequences.</summary>
		/// <returns> The <tt>SELECT</tt> command; or NULL if sequences are not supported. </returns>
		public override string QuerySequencesString
		{
			get { return "SELECT SEQUENCE_NAME FROM SYS.SYSSEQUENCE"; }
		}
 
 
		public override string GetSequenceNextValString( string sequenceName )
		{
			return "SELECT " + GetSelectSequenceNextValString(sequenceName) + " FROM SYS.DUMMY";
		}
 
		public override string GetSelectSequenceNextValString( string sequenceName )
		{
			return sequenceName + ".NEXTVAL";
		}
 
		public override string GetCreateSequenceString( string sequenceName )
		{
			return "CREATE SEQUENCE " + sequenceName; // by default, is START WITH 1 MAXVALUE 2**63-1
		}
 
		public override string GetDropSequenceString( string sequenceName )
		{
			return "DROP SEQUENCE " + sequenceName;
		}
 
	}
}