c# - getting timeout error on dbtransaction -
i getting timeout error thrown. how can increment amount of time before transaction times out?
database dbsvc = databasefactory.createdatabase(); //use 1 connection using (dbconnection conn = dbsvc.createconnection()) { conn.open(); dbtransaction transaction = conn.begintransaction(); seek { .... } grab (exception ex) { transaction.rollback(); ret.issuccess = false; ret.exceptioninfo = ex; } { ret.invoiceinfo = invoiceout; }
thanks!
if using ado.net add together timeout property connection string. increment accordingly until no longer times out, if adding timeout property should looking @ db , analyzing weaknesses such lack of indexes can done via analyzing queries via sql profilier.
c# asp.net sql-server connection-timeout
No comments:
Post a Comment