CODEWITHSUNDEEP
c#sqlreader
user6911980
user6911980

Reputation:

Get the ID of the column being read in SqlDataReader

I'm currently reading from an ancient stored procedure.

I know you can get the FieldType and FieldCount to get type/size of the columns but is there a way to get the actual ID of the column to read from the reader?

The ID I'm referring to is this:

SqlDataReader reader = cmd.ExecuteReader();
while(reader.Read())
{
    SomeObject obj = new SomeObject{
        SomeProperty = reader["ID"]
    };
}

I don't want to bind it arbitrarily to some var but to obtain the actual column name it's returning in the results set if possible?

Upvotes: 1

Views: 271

Answers (1)

Oleg Bondarenko
Oleg Bondarenko

Reputation: 1820

You could do something like that and gather all name that contains in reader: 

var columns = Enumerable.Range(0, reader.FieldCount).Select(reader.GetName).ToList();

Upvotes: 1

Related Questions