Hi Guys,

We were planning to migrate our applications into C#. We are very much concern on how to get the newly autoincrement value from the datasource. Our main concern lies in Datatables wherein there is a parent and a child relation. Is it possible to use the autoincrement as the Primary and Foreign key for the Parent and child table respectively? If there are more than one concurrent users accessing the Datasource, how would the system know whether it got the right autoincrement number. We are looking at SCOPE_IDENTITY() to get the newly generated autoincrement. How does it work?

Thanks...