I am following way for C#.NET Programs..Keeping in mind that many user will use program at a time
STEP 1 : Generate Unique Id from any table
STEP 2 : Generate transaction in following way
SqlConnection Con = new SqlConnection; Con.BeginTransactionSTEP 3: My sql statements(Insert/Update/Delete)
STEP 4: Commit or Rollback
just need whether I should do any changes or not.Is the above way is good if there are more users using software at a time.
Manoj BhoirPosted Jul 6, 2015, 11:53 AM
Mayur GujrathiPosted Jul 6, 2015, 11:50 AM
Manoj BhoirPosted Jul 5, 2015, 8:30 AM
As you said in your question it looks like you are not using entity framework or any ORM frameworks.
Your logic is absolutely correct for single as well as multiple users.
Just make sure that you are disposing all unused objects properly while performing any transactions on database and that’s it.
For more details about Transaction check these links