Want to build the ChatGPT based Apps? Start here
Become a member
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
C# Corner Home
Technologies
Monthly Leaders
ASK A QUESTION
Forum guidelines
Hold On
1.2k
1.1k
216.4k
How to get the last inserted row number?
Apr 6 2021 5:43 PM
This question may seem very very easy (Select COUNT(Id), but in my case is different. I developed a web application with 15 to 25 concurrent users. every time they open the program, I am checking the last row inserted into the database and in C# I created a serial number based on the last row inserted + 1. So say for example below entry:
User1 opens up the program:
DB count = 1
C# Series = Ser-00001 (displayed in UI)
User1 inserts a row. success
User2 opens up the program:
DB count = 2
C# Series = Ser-00002 (displayed in UI)
User2 inserts a row. success
User3 opens up the program:
DB count = 3
C# Series = Ser-00003 (displayed in UI)
User3 inserts a row. success
No issue right? But, there will be a time that 2 or more users will open the program at the same time. Now, below is the scenario
User7 opens up the program:
DB count = 4
C# Series = Ser-00004 (displayed in UI)
User7 inserts a row. success
User8 opens up the program:
DB count = 4
C# Series = Ser-00004 (displayed in UI)
User8 inserts a row. failed
User9 opens up the program:
DB count = 4
C# Series = Ser-00004 (displayed in UI)
User9 inserts a row. failed
This time a big problem suddenly occur!
Now my question is, how do you do it to avoid this type of duplication? Thank you in advance for any posible solution.
Reply
Answers (
6
)
VS and GitHab Connection problem
.NET 3.5 reference dll not found on .NET 2.0 Windows Server 2003