sqlcommand.executereader returns null

Asked Aug 06 '21 at 13:52

Active Aug 06 '21 at 14:09

Viewed 39 times

After calling this procedure :

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

ALTER PROCEDURE [dbo].[SLTxtMainGetAll]
AS
BEGIN
    SET NOCOUNT ON;

    SELECT [Id]
      ,[IsAnnouncement]
      ,[Text]
      ,[TextLanguage] 
    FROM SLTxtMain;
END

C# code calling this procedure is:

private SqlDataReader _reader;

_command = _connection.CreateCommand();
_command.Transaction = _transaction;
_command.CommandTimeout = 300;
_command.CommandType = CommandType.StoredProcedure;
_command.CommandText = "SLTxtMainGetAll";

_reader = _command.ExecuteReader(); // This returns null

What's happening? Where might be a problem?

edited Aug 06 '21 at 14:09

marc_s

732,580
175
1,330
1,459

asked Aug 06 '21 at 13:52

Aleister357

1

It shouldn't return null. Try to create a simple repro, and post that if you can. – David Browne - Microsoft Aug 06 '21 at 14:06
You shouldn't cache connection, command and reader objects anyway. Create when you need, dispose with `using` as soon as you are fininshed – Charlieface Aug 06 '21 at 15:34
yo problem was Connection OPEN CLOSE and connection string – Aleister357 Aug 07 '21 at 11:36

sqlcommand.executereader returns null

0 Answers0