Hey everybody, I got a question here...
I am not sure what is the best approach to make commits to the DB.
For example, I have a method that is InsertNewRecordInDB(RecArgs() as string)
So If I commit inside that method, then I will not be able to use it to batch insert records, because every insert will be commited and I want to commit after the whole transaction (all inserts) are done.
But If I don't commit inside the method, that I must always remember to commit after calling the method, which is not very safe (Considering that method might be called from another method, and so on...)
What do you guys, think ?