Auto Incrementing number

Question

4.00/5 (1 vote)

See more:

Hi all,

Can anybody tell me how to create an Auto Incrementing number for an sql data field using linq?

Thanks in advance.

Posted 5-Dec-10 21:51pm

Starlene

Updated 5-Dec-10 22:32pm

thatraja

v3

Add a Solution

Comments

Dalek Dave 6-Dec-10 4:12am

Minor Edit for Grammar and Readability.

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Answer 1 · 2010-12-05T22:13:00

You don't need to do it - Sql AutoNumner fields are created and maintained by the database. You cannot assign them in your code - that is the whole point!

Depending on what you are doing, you may want to consider using Guids rather than autonumber - If you insert a record, then have to find it to use it's autonumber field elsewhere, then definitely look at Guid instead. They have a lot of advantages, particularly when it comes to replication.

Autonumber is fine for a log table (and so forth) when you don't need to refer to the record again, but that's about it!

Dylan Morley · Answer 2 · 2010-12-05T22:15:00

Solution 2

You're best off leaving this to the database - are you using SQL Server?

If so, create a field with an integer data type and set it to Identity = Yes in the designer.

Whenever a new record is added, this field will auto increment.

Posted 5-Dec-10 22:15pm

Dylan Morley

SunilChavan1 · Answer 3 · 2010-12-05T23:14:00

Solution 3

I would suggest let SQL Server do the incremental numbering by using autonumber.In your scenario if you will do from front end then chances on duplicate inserts due in case of multiuser system.

:) :)

Posted 5-Dec-10 23:14pm

SunilChavan1