Executereader return null

It does not matter if a specific implementation for ExecuteReader will not allow to bubble up a null value - the fact remains that IDataReader is an object which can contain or point to null. You do not need to know what happens inside the implementation of an interface in order to use it correctly - you just need to know the interface, and right now the interface allows null as a return value.

I had this issue with them in a couple of other areas. It seems they've done an analysis of the code paths in the various parts of the CLR. When they find that it's conceivable to return null, that's when they complain about it. In the particular case I complained about, null couldn't actually happen. However, they traced the call graph down to a method which could return null, under some circumstances, and the null value could conceivably propagate to the top.

In the case where I was getting a null, I had sent my client a script to update a stored procedure. My client's Sql Server is set up so that DB users need a permission to execute a stored procedure. When they updated the SP the permission was removed and not re-assigned.

In this instance the SqlCommand. ExecuteReader returned a null. For me it was not null, but would output nothing when viewed in Powershell. This would happen when the query returned no rows. Stack Overflow for Teams — Collaborate and share knowledge with a private group. Create a free Team What is Teams? ExecuteReader requires an open SqlConnection. The SqlConnection closed or dropped during a streaming operation.

When the CommandType property is set to StoredProcedure , the CommandText property should be set to the name of the stored procedure. The command executes this stored procedure when you call ExecuteReader. If a transaction is deadlocked, an exception may not be thrown until Read is called.

The multiple active result set MARS feature allows for multiple actions using the same connection. One of the CommandBehavior values. CommandBehavior is set to CloseConnection. Use SequentialAccess to retrieve large values and binary data. Let's work to help developers, not make them feel stupid. Related Questions. Python, my SQL query return 0 rows.

Htmlagilitypack return null value on documentnode. Subquery returns more than 1 row. Sqldatareader is not returning values. Stored procedure returning only first row. Sql query to retreive data from database on daily basis if present data data not present return null.

Return default image if it return null in SQL Query. Layout: fixed fluid. Web01 2. Strip HTML. Encode HTML. Paste as-is. Code block. Quoted Text. Best guess. Well, it returns only row. I forgot to mention My table has multiple rows, how do I return them properly? Ask a question. Quick access. Search related threads. Remove From My Forums. Answered by:. Archived Forums. Visual C. Sign in to vote.