I do not wish to have to change the application code if possible. The current data access in done with Ado.net mostly Datasets and table adaptors.
Most (all) of the current sql statements in the application are simple enough to work on both oracle and sqlserver with no changes. (apart from a string.replace() to convert @ in parameter names)
Answer by Jonah H. Harris ·
In Oracle, you create a number column and use a sequence. A good reference for you would likely be Oracle for SQL Server Developers, Vol. 4: Identity Columns & Sequences.