Sequence
A multiple instance and thread safe unique number sequence generator.
Replicates the create sequence transact-SQL functionality (http://msdn.microsoft.com/en-us/library/ff878091.aspx) in a .Net assembly.
What's the point?
The 'Create Sequence' command is not supported on Sql Azure: (https://connect.microsoft.com/SQLServer/feedback/details/723601/support-native-sequences-in-sql-azure)
You can now use any Sql or NoSql database to store your sequence. Just implement IStateStore.
When using Azure table storage as the store state
Install
``` Install from Nuget:PM> Install-Package getAddress.Sequence.Azure
<h3>Usage</h3>
static void Main(string[] args) { Run().Wait();
Console.Read();
}
private async static Task Run() {
var stateProvider = AzureStateProviderFactory.Get("" /* Your azure storage connection string*/, "mySequenceTable" /*or any table name*/);
var sequence = await stateProvider.NewAsync(new SequenceOptions
{
Cycle = false,
Increment = 1,
MaxValue = 100,
MinValue = 0,
StartAt = 0
});
var sequenceKey = await stateProvider.AddAsync(sequence);
var sequenceGenerator = new SequenceGenerator(stateProvider);
for (int i = 0; i < 10; i++)
{
Console.WriteLine(await sequenceGenerator.NextAsync(sequenceKey));
}
}
<h3>Output</h3>
1 2 3 4 5 6 7 8 9 10
<h2>When using SQL Server as the store state</h2>
<h3>Install</h3>
Install from Nuget:
PM> Install-Package getAddress.Sequence.SqlServer
<h3>Usage</h3>
static void Main(string[] args) { Run().Wait();
Console.Read();
}
private async static Task Run() {
var stateProvider = SqlServerStateProviderFactory.Get("" /* Your connection string*/);
var sequence = await stateProvider.NewAsync(new SequenceOptions
{
Cycle = false,
Increment = 1,
MaxValue = 100,
MinValue = 0,
StartAt = 0
});
var sequenceKey = await stateProvider.AddAsync(sequence);
var sequenceGenerator = new SequenceGenerator(stateProvider);
for (int i = 0; i < 10; i++)
{
Console.WriteLine(await sequenceGenerator.NextAsync(sequenceKey));
}
}
<h3>Output</h3>
1 2 3 4 5 6 7 8 9 10
<h2>When using Mongo as the store state</h2>
<h3>Install</h3>
Install from Nuget:
PM> Install-Package getAddress.Sequence.Mongo
<h3>Usage</h3>
static void Main(string[] args) { Run().Wait();
Console.Read();
}
private async static Task Run() {
var stateProvider = MongoStateProviderFactory.Get("" /* Your connection string*/);
var sequence = await stateProvider.NewAsync(new SequenceOptions
{
Cycle = false,
Increment = 1,
MaxValue = 100,
MinValue = 0,
StartAt = 0
});
var sequenceKey = await stateProvider.AddAsync(sequence);
var sequenceGenerator = new SequenceGenerator(stateProvider);
for (int i = 0; i < 10; i++)
{
Console.WriteLine(await sequenceGenerator.NextAsync(sequenceKey));
}
}
<h3>Output</h3>
1 2 3 4 5 6 7 8 9 10
React
Typescript
Django
Laravel
Facebook
Microsoft
Google
Alibaba
D3
Tencent