Enterprise Data Blocks and command timeout

15 Dec 2006 7:01 AM

MarkusJNZ

Hi, I am using 2.0 DAB to return a datareader (ASP.NET 2.0)

// Create a database object
Database db =
DatabaseFactory.CreateDatabase("ConnectionString");

I then use the following to return a dataReader

IDataReader _reader = db.ExecuteReader(CommandType.StoredProcedure,
"spStoredProcedureName");

I am experienceing problems where the command times out. How can I set
the command object timeout property when using the above code to
execute a stored procedure against the database??

thanks in advance
Markus

15 Dec 2006 10:06 AM

Yves. L.

Hi,
You should add a <<Timeout>> property in your database connection string
settings .
Yves

Markus***@gmail.com wrote:
Show quote

> Hi, I am using 2.0 DAB to return a datareader (ASP.NET 2.0)
>
> // Create a database object
> Database db =
> DatabaseFactory.CreateDatabase("ConnectionString");
>
> I then use the following to return a dataReader
>
> IDataReader _reader = db.ExecuteReader(CommandType.StoredProcedure,
> "spStoredProcedureName");
>
> I am experienceing problems where the command times out. How can I set
> the command object timeout property when using the above code to
> execute a stored procedure against the database??
>
> thanks in advance
> Markus
>

15 Dec 2006 1:23 PM

Plamen Ratchev

Hi Markus,

To set the timeout property for the command you have to use an ADO.NET
DbCommand object. Setting the timeout on the connection string will not work
as it is the connection timeout not the command timeout.

For example:

// Create a database object
Database db = DatabaseFactory.CreateDatabase("ConnectionString");
DbCommand dbCommand = db.GetStoredProcCommand("spStoredProcedureName");
dbCommand.CommandTimeout = 600; // Set command timeout to 600 seconds
IDataReader _reader = db.ExecuteReader(dbCommand);

For more info on DbCommand see:
http://msdn2.microsoft.com/en-us/library/system.data.common.dbcommand.commandtimeout.aspx

Regards,

Plamen Ratchev
http://www.SQLStudio.com

<Markus***@gmail.com> wrote in message
Show quote

news:1166166117.638849.151410@80g2000cwy.googlegroups.com...
> Hi, I am using 2.0 DAB to return a datareader (ASP.NET 2.0)
>
> // Create a database object
> Database db =
> DatabaseFactory.CreateDatabase("ConnectionString");
>
> I then use the following to return a dataReader
>
> IDataReader _reader = db.ExecuteReader(CommandType.StoredProcedure,
> "spStoredProcedureName");
>
> I am experienceing problems where the command times out. How can I set
> the command object timeout property when using the above code to
> execute a stored procedure against the database??
>
> thanks in advance
> Markus
>

15 Dec 2006 10:27 PM

MarkusJNZ

Thanks everyone for your help
Regards
Markus
Plamen Ratchev wrote:
Show quote

> Hi Markus,
>
> To set the timeout property for the command you have to use an ADO.NET
> DbCommand object. Setting the timeout on the connection string will not work
> as it is the connection timeout not the command timeout.
>
> For example:
>
> // Create a database object
> Database db = DatabaseFactory.CreateDatabase("ConnectionString");
> DbCommand dbCommand = db.GetStoredProcCommand("spStoredProcedureName");
> dbCommand.CommandTimeout = 600; // Set command timeout to 600 seconds
> IDataReader _reader = db.ExecuteReader(dbCommand);
>
> For more info on DbCommand see:
> http://msdn2.microsoft.com/en-us/library/system.data.common.dbcommand.commandtimeout.aspx
>
> Regards,
>
> Plamen Ratchev
> http://www.SQLStudio.com
>
>
> <Markus***@gmail.com> wrote in message
> news:1166166117.638849.151410@80g2000cwy.googlegroups.com...
> > Hi, I am using 2.0 DAB to return a datareader (ASP.NET 2.0)
> >
> > // Create a database object
> > Database db =
> > DatabaseFactory.CreateDatabase("ConnectionString");
> >
> > I then use the following to return a dataReader
> >
> > IDataReader _reader = db.ExecuteReader(CommandType.StoredProcedure,
> > "spStoredProcedureName");
> >
> > I am experienceing problems where the command times out. How can I set
> > the command object timeout property when using the above code to
> > execute a stored procedure against the database??
> >
> > thanks in advance
> > Markus
> >

15 Dec 2006 10:28 PM

Robson Siqueira

Markus,

You have the following options:

a) determine the default timeout for your connection string
b) create a command, defining the timeout and then using that command to
create the reader

Specifically to b, the code would look like:

Database db = DatabaseFactory.CreateDatabase("teste");

DbCommand cmd = db.GetStoredProcCommand("your stored procedure");

cmd.CommandTimeout = 10000;

IDataReader _reader = cmd.ExecuteReader();

I hope it helps.

Robson,

<Markus***@gmail.com> wrote in message
Show quote

news:1166166117.638849.151410@80g2000cwy.googlegroups.com...
> Hi, I am using 2.0 DAB to return a datareader (ASP.NET 2.0)
>
> // Create a database object
> Database db =
> DatabaseFactory.CreateDatabase("ConnectionString");
>
> I then use the following to return a dataReader
>
> IDataReader _reader = db.ExecuteReader(CommandType.StoredProcedure,
> "spStoredProcedureName");
>
> I am experienceing problems where the command times out. How can I set
> the command object timeout property when using the above code to
> execute a stored procedure against the database??
>
> thanks in advance
> Markus
>

19 Dec 2006 12:37 PM

sloan

There is a command timeout and a connection timeout.. They are not the same
things.

in the1.1 Ent Lib, I had to code up an overload to specify a larger command
timeout.

I have the 2.0 library (not handy unforunately).....and haven't looked at it
yet, but it is probably the same.

<Markus***@gmail.com> wrote in message
Show quote

news:1166166117.638849.151410@80g2000cwy.googlegroups.com...
> Hi, I am using 2.0 DAB to return a datareader (ASP.NET 2.0)
>
> // Create a database object
> Database db =
> DatabaseFactory.CreateDatabase("ConnectionString");
>
> I then use the following to return a dataReader
>
> IDataReader _reader = db.ExecuteReader(CommandType.StoredProcedure,
> "spStoredProcedureName");
>
> I am experienceing problems where the command times out. How can I set
> the command object timeout property when using the above code to
> execute a stored procedure against the database??
>
> thanks in advance
> Markus
>