asp.net get Last Id threats

asp.net get Last Id threats

I have to tables , first one is [TempTable1] and second is [Table1] .First
I insert data into [TempTable1] , after updating [confirmed] column in it
, a Trigger [trigger1] moves a specific record depend on ID to [Table1] ,
what I want here is to get currently added record ID of the [Table1] in c#
code , I thought about getting last record, but what I afraid of is
conflating , because when a user confirms its data , they will transformed
from [TempTable1] to [Table1] , and maybe user2 do the same , user3 also
and so on.. if I always get last added id , may some users net is slow and
it takes time for server to do the transformation , someones net is quick
, its data maybe added before first user get its respond by getting its
id, so may some ones id goes to another one when I get it in c# code and
do operation on it , am I true or there is no threat in doing this ?