idbcommand

How to obtain the IDbCommand output to the DB? (.NET)

I have a SqlCommand object, and I execute its ExecuteNonQuery method. The query fails, but I can't see how to obtain the query to debug it. Could you help me? Update I am currently using Wireshark (tcpdump) to read the command, but I think that its not the best solution Update The CommandText property only provides the Stored Procedure...

Is there a way to use a generic DbCommand to do an Asynchronous update?

When using a generic DbCommand to perform an update, it will hang indefinately if the row being updated is locked. The underlying connection used is is Devart's Oracle provider, Devart.Data.Oracle.OracleConnection Setting the DbCommand.CommandTimeOut has no effect at all, the update never times out. DbCommand does not implement BeginE...

SQL Server Physical Memory Grow After Execution of Commands

Dear GURUs I am running Server Application on Windows Server 2008 with SQL Server 2008, Now My scenario is as Given. I have implemented a custom Connection Pooling (why I did that its another long story). therefore I am not opening or closing connection on each request. Server Application executes more than thousands DBCommand in a m...

Select Statement in ASP.NET (VB) using Parameters - Error: Input string was not in a correct format.

So I have some code in a VB module. When I run this with the SQL statement having hard coded values in the where statement it works. I am now trying to add Parameters to the module so that the Form can except an Input from a user, but I am getting the message: Input string was not in a correct format. Here is the section of code: o...