Hi all,
I have an application, which requires several SQL activities, so I wrap
them in a transaction:
SqlConnection conn = new SqlConnection(c onnectionString );
conn.Open();
SqlTransaction tran = conn.BeginTrans action(Isolatio nLevel.ReadUnco mmitted);
I use MS Application Block for Data Access to handle all SQL statements:
SqlHelper.Execu teNonQuery(tran , CommandType.Tex t, sql);
I have following 2 problems:
1) When I debug this application from my local machine, in the middle of
this transaction, I cannot use my Sql Query Analyzer to do anything against
some tables used in this transaction, even though I set transaction's
isolation level to read uncommitted. Until I finish my debugging, result
will return from query analyzer.
2) I have a common class, and it contains a function shared by some other
functions,
public bool Audit(SqlTransa ction tran) {
string sql = "insert into AuditTable ....";
try {
SqlHelper.Execu teNonQuery(tran , CommandType.Tex t, sql);
return true;
} catch (Exception ex) {
return false;
}
}
Every other function passes its own transaction object to this function.
I frequently find dead lock caused by sql statement in this function. Is
there any limitation to use transaction object across classes? The other
funny thing is, the audit table is used to be inserted only, no other piece
of code will read/write to this table, so how comes this relative
independent table will cause dead lock?
Welcome to any comment.
Thanks!
--
WWW: http://hardywang.1accesshost.com
ICQ: 3359839
yours Hardy
I have an application, which requires several SQL activities, so I wrap
them in a transaction:
SqlConnection conn = new SqlConnection(c onnectionString );
conn.Open();
SqlTransaction tran = conn.BeginTrans action(Isolatio nLevel.ReadUnco mmitted);
I use MS Application Block for Data Access to handle all SQL statements:
SqlHelper.Execu teNonQuery(tran , CommandType.Tex t, sql);
I have following 2 problems:
1) When I debug this application from my local machine, in the middle of
this transaction, I cannot use my Sql Query Analyzer to do anything against
some tables used in this transaction, even though I set transaction's
isolation level to read uncommitted. Until I finish my debugging, result
will return from query analyzer.
2) I have a common class, and it contains a function shared by some other
functions,
public bool Audit(SqlTransa ction tran) {
string sql = "insert into AuditTable ....";
try {
SqlHelper.Execu teNonQuery(tran , CommandType.Tex t, sql);
return true;
} catch (Exception ex) {
return false;
}
}
Every other function passes its own transaction object to this function.
I frequently find dead lock caused by sql statement in this function. Is
there any limitation to use transaction object across classes? The other
funny thing is, the audit table is used to be inserted only, no other piece
of code will read/write to this table, so how comes this relative
independent table will cause dead lock?
Welcome to any comment.
Thanks!
--
WWW: http://hardywang.1accesshost.com
ICQ: 3359839
yours Hardy
Comment