Friday, 15 March 2013

c# - getting timeout error on dbtransaction -



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