This is a very nice article about Firebird generators: Firebird Generator Guide

Show what a Generator is in Firebird and how and why to use it. This is the attempt to collect all relevant information about Generators in a single document - hope it works, too... Who should read it?

Read this article if you:

• are not familiar with the concept of Generators
• have questions on using them
• want to make an Integer column behave like an "AutoInc" field as found in other RDBMSs
• are looking for examples on how to use Generators for IDs or other tasks
• want to know the Firebird word for a "sequence" in Oracle ;-)

Table of contents:

Chapter 1: Generator basics

Chapter 2: Using Generators (in general)

Chapter 3: Using Generators to create unique row IDs

Chapter 4: Using Generators with IBObjects

Chapter 5: What else to do with Generators ( and why most of it won't work ;-)

Glossary

Search Firebird Questions .NET:
Sequence
Generator

The final version of the Firebird ADO.NET client for .NET Framework 2.0 is here. This is a summary of the new features:

• Visual Studio 2005 integration of the provider using a DDEX provider
• Support for the new INSERT ... RETURNING statement of Firebird v2.0
• Support for the new PSQL stack trace of Firebird v2.0
• New CAS support FirebirdClientPermission and FirebirdClientPermissionAttribute classes
• Added support to the new CREATE SEQUENCE statement to the FbBatchExecution class.
• Implemented FbParameterCollection.AddWithValue
• New GDS implementation for the Firebird/Fyracle External Proceudre engine implementation.
• Added a new namespace FirebirdSql.Data.StoredProcedureEngine with two new classes: FbResultSet, FbTriggetContext
• Added initial support for boolean input parameters.
• [DDEX] Foreign keys should be now automaticalled added to DataSets at design time when dropping tables from the Server Explorer.
• Added correct support for the new .net 2.0 DbParameter.SourceColumnNullMapping property (Alexander V. Leshkin)
• Initial implementation of the new extended support for char/varchar fields with OCTETS character set.
• Added initial support for EXECURE PROCEDURE commands in FbBatchExecution class.
• Added new Connection String parameter "Context Connection" to be used with .NET stored procedure implementations for Fyracle.
• Added new UTF8 ( Firebird 2.0 only ) character set.
• Added a new Role Provider implementation ( FirebirdSql.Web.Providers assembly )

The new version is available in the downloads section.

Search Firebird Questions .NET:
Server Explorer
FirebirdClient
FirebirdClientPermission
CREATE SEQUENCE
FbParameterCollection
FbBatchExecution
UTF8
GDS

New development versions available:

• Firebird Server for Windows 2.0 RC 2
• Embedded Firebird for Windows 2.0 RC 2
• FirebirdClient 2.0 RC5 for .NET Framework 2.0

Available in downloads section.