Additional context: using Sharp Architecture to implement a .NET WCF REST
API, which uses Fluent NHibernate to access a single SQL Server DB
instance. The REST API is load balanced across multiple servers and will
be inserting into a SQL Server table that uses an auto-increment integer
primary key.
Is this configuration valid? Is this architecture valid? ie. - is there
specific configuration or coding required to avoid collisions on the single
auto-increment column when simultaneously accessed from multiple REST API
instances?