Transaction in dotNET and SqlServer
-
Hi there . During transaction is began , I inserted new data in table , until I don't call commit() or rollback() functions , another processes can not access to this table. I mean, if i try to add a new data in a table with transaction and before closing transaction(commit or rollback) another process can't read that table; then a exception will occurred. what is the problem?
-
Hi there . During transaction is began , I inserted new data in table , until I don't call commit() or rollback() functions , another processes can not access to this table. I mean, if i try to add a new data in a table with transaction and before closing transaction(commit or rollback) another process can't read that table; then a exception will occurred. what is the problem?
Developer611 wrote:
what is the problem?
Didn't I just answer this in the SQL Forum? Would it be too much to ask that you only post the question once?
Upcoming events: * Glasgow: Mock Objects, SQL Server CLR Integration, Reporting Services, db4o, Dependency Injection with Spring ... "I wouldn't say boo to a goose. I'm not a coward, I just realise that it would be largely pointless." My website
-
Hi there . During transaction is began , I inserted new data in table , until I don't call commit() or rollback() functions , another processes can not access to this table. I mean, if i try to add a new data in a table with transaction and before closing transaction(commit or rollback) another process can't read that table; then a exception will occurred. what is the problem?
Developer611 wrote:
what is the problem?
It's by design, read the sections on TransactionScope.
**
xacc.ide-0.2.0.77 - now with C# 3.5 support and Navigation Bar!^
New xacc.ide release RSS feed^**