SqlDataReader has no Connection property

Question

I am using .NET Framework 4.5 in Visual Studio 2012 and read its help on http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqldatareader.connection.aspx. But in my code I cant get access to this property - it is inaccessible to a copy of SqlDataReader. How can I get readers SqlConnection ?

Can you share your code?? As it would help to understnd your problem better!!! — Rahul Tripathi
– Rahul Tripathi, Commented Aug 24, 2013 at 14:55
Why do you need to access it? The SqlCommand you have used to get the SqlDataReader has a public property Connection. — Tim Schmelter
– Tim Schmelter, Commented Aug 24, 2013 at 14:58
I need it because I dont want pass two arguments to the method instead of one. — John Stiks
– John Stiks, Commented Aug 24, 2013 at 15:05
Why do you pass a SqlDataReader to another method at all? You should consume it where you executed it. — Tim Schmelter
– Tim Schmelter, Commented Aug 24, 2013 at 15:07
To reduce number of cycles in one method. I give him to other method and there already in a cycle I read out fields. — John Stiks
– John Stiks, Commented Aug 24, 2013 at 15:08

kmatyaszek · Accepted Answer · 2013-08-24 14:55:57Z

3

You can't access it because this property is protected:

protected SqlConnection Connection { get; }

answered Aug 24, 2013 at 14:55

kmatyaszek

19.3k9 gold badges62 silver badges66 bronze badges

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

1 Answer 1