Increase SQL timeout with Enterprise Library

[ujjc001]

Hello all-
I'm using the enterprise library for my data calls. I have a sql query
that takes a long time to run and would like to increase the timeout
for that one single call. If I step into the ent lib code I can get at
the connection timeout property and increase that, but I can't get at
it from my code. Any thoughts?
Thanks.
Jeff

 

[ujjc001]

anyone?

 

[ujjc001]

no one? (Just replying a few more times to get back on the main page
for google groups)...

 

[king88uy7]

DbCommand.CommandTimeout

 

[soyelporras]

Setting command timeout using Enterprise Library

Use this
dcCommand = dDatabase.GetSqlStringCommand(sSQLCommand);
dcCommand.CommandTimeout = 60;
dDatabase.LoadDataSet(dcCommand, dsDataSet , saTableNames);

Instead of this
dDatabase.LoadDataSet(CommandType.Text, sSQLCommand, dsDataSet , saTableNames);

 

[covalle]

Hi man,

Look at this


Public Function ConsultarDataset_TimeOut(ByVal Prodecimiento As String, ByVal Parametros As Object()) As DataSet
Try
Dim dcCommand As System.Data.Common.DbCommand
dcCommand = _db.GetStoredProcCommand(Prodecimiento, Parametros)
dcCommand.CommandTimeout = 200

Return _db.ExecuteDataSet(dcCommand)
Catch ex As SqlException
HandleSqlException(ex)
End Try
Return Nothing
End Function


regards, and good proggrammings

Hello all-
I'm using the enterprise library for my data calls. I have a sql query
that takes a long time to run and would like to increase the timeout
for that one single call. If I step into the ent lib code I can get at
the connection timeout property and increase that, but I can't get at
it from my code. Any thoughts?
Thanks.
Jeff