How to write CommandBehaviour.CloseConnection() in VS2008?

sarangrao

iaM NOT ABLE TO WRITE CommandBehavior.CloseConnection() in VS2008?

Plater

I'll take your word that you cannot.
If you just want to close your database connection, consider calling the Close() function on the connection object?

sarangrao

CommandBehaviour is a property of something.but i don't remember?

Plater

Quote:

Originally Posted by sarangrao

CommandBehaviour is a property of something.but i don't remember?

If you don't remember what its a property of, maybe its still there, but you haven't found the right object yet?

codegecko

It's a property of a DataReader according to MSDN.

Try this:

Expand|Select|Wrap|Line Numbers

 
DbDataReader dr = yourCommand.ExecuteReader();

dr.CommandBehaviour = CommandBehaviour.CloseConnection;
 
while (dr.Read()) {

    //Iteration logic here

}

Let us know if this works.

codegecko

sarangrao

dr does not contain property called Command Behaviour

ryachza

A. CommandBehavior is an enumeration, so it would be CommandBehavior.CloseConnection (no parentheses).

B. The only way I know of to specify the command behavior of a datareader is by passing the value (CommandBehavior.CloseConnection) when calling ExecuteReader() on a given command object.

How to write CommandBehaviour.CloseConnection() in VS2008?

re: How to write CommandBehaviour.CloseConnection() in VS2008?

re: How to write CommandBehaviour.CloseConnection() in VS2008?

re: How to write CommandBehaviour.CloseConnection() in VS2008?

re: How to write CommandBehaviour.CloseConnection() in VS2008?

re: How to write CommandBehaviour.CloseConnection() in VS2008?

re: How to write CommandBehaviour.CloseConnection() in VS2008?

Similar .NET Framework bytes

/bytes/development

/bytes/it

/bytes/about