Using a Stored Procedure To Generate Primary Key

Question

User-677746510 posted

I'm creating a web application using a web form which essentially transfers data from an excel sheet to a table. I'm using the EPPlus library to do all of that, and have a working connection. My question is how do I use an already existing stored procedure for determining my primary key, and implement that into my application? What does that look like? Sorry if this is very simple, but I am new to ASP.NET and C#. Thanks!

Answer 1

User753101303 posted

Hi,

Which db are you using? What does this existing procedure ? Usually generating a new primary key value is a db built in feature. For example with SQL Server :

https://docs.microsoft.com/en-us/sql/t-sql/statements/create-table-transact-sql-identity-property

If you have been told to use an existing procedure it should already handle this correctly. Usually in case you need it, the procedure usually returns the newly inserted id (ask them how, you have multiple ways to return this value).

Or give some more details if you need further help.

Answer 2

User364663285 posted

If you're using SQL server, you can define column as Identity to let database create the key for you.

If You're using Oracle, you can create a sequence for such purpose.