Sequences
Table Of Contents
What are Sequences?
This feature in The Sharp Factory Framework allows the developer to call SQL Sequences.
Sequences in SQL generate sequential numbers much like Identity fields. These incremental numbers are global to the entire database.
These sequences are bound to a particular SQL Schema.
The Sharp Factory App generates a method per SQL Sequence added to the model.
The naming convention is RepositoryContainer.{Model Name}.{SQL Schema}.Sequences.{Sequence Name}
Calling Sequences
The following C# code sample shows how to consume a SQL Sequence called CustomerID.
C#