hi,
Is it over head to use SqlTransaction(begin, commit, rollback) for a single transaction.
am not using application block or enterprise library.
only a single insert statement.
Yes, SQL Transactions are an overhead to SQL Server whether you are writing a single query or a batch of queries, but on the other side you are rest assured that in case of any errors you can always rollback the transaction and on successful execution only you will commit transaction.
Have a look at Trasactions in SQL BOL.
Hope this will help.
hi
i dont think that using the sqlTransaction causes any overhead ...
regards,
No comments:
Post a Comment