I am creating a product control of a company, in which we need to generate sequential codes for products as they are registered, we sell digital products, so there is no physical quantity. At first I thought of using a field of auto increment, but we have another problem: We sell the products in packages, that is, it would need several simultaneous downloads, because 1 in 1 would not make much sense or would take more time. I also heard about the SEQUENCE function (Implemented in SQL Server 2012).
What would be the best suggestion for a database?
The interface I thought of using C # as well as using SQL Server for the database.
What do you suggest?