C# SqlDataReader interface with HasRows, Read() and NextResult()

Question

I am trying to find an interface which is implemented by SqlDataReader and which exposes HasRows, Read() and NextResult(). I need these property and methods because I need to read multiple resultSets returned by stored procedures (as mentioned here). Currently I am using System.Data.IDataReader which exposes Read() and NextResult() but not HasRows property.

I need an interface so that the coupling will be lose and for the sake of code testability.

Any help on such an interface? Or I'll need to write an abstraction layer of interface from scratch?

Why dont you implement IDataReader for Read() and NextResult() in your own Interface and then implement your own custom interface for hasRows this will reduce your scratchwork — Zain Ul Abidin
– Zain Ul Abidin, Commented Oct 29, 2016 at 9:32
IDataReader itself is fine because IDataReader.NextResult() returns a bool so you can do do { ... } while (reader.NextResult()); See for instance this answer. — dbc
– dbc, Commented Oct 31, 2016 at 6:54

usr · Accepted Answer · 2016-10-29 14:12:43Z

3

HasRows is not needed for anything (usually it's being used redundantly because people don't know any better). The standard pattern is:

while (reader.Read()) ...

So this obviates the need for the interface you are looking for.

answered Oct 29, 2016 at 14:12

usr

172k38 gold badges251 silver badges380 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

C# SqlDataReader interface with HasRows, Read() and NextResult()

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related