how to parse data from array of objects

Question

I got ienumerable method which I read data from database and this data i put in array of object

while (reader.Read())
{
    var values = new object[reader.FieldCount];
    reader.GetValues(values);
    yield return values;
}

And in another method i'm iterating these objects

foreach (var items in repo.ExecuteReader()
   {
        rss.Id = items[0]; // not work
        yield return items;
   }

How can I indexing there array of 'items'?

@TimBourguignon, It says that: "cannot apply indexing with [] to an expression of type 'object'" — semper fi, Apr 12 '16 at 09:59
@HariPrasad, object does not contain definition about items.First() — semper fi, Apr 12 '16 at 10:03
Try using this `foreach (object[] items in repo.ExecuteReader())`. — Hari Prasad, Apr 12 '16 at 10:07
Oh, nice one, that works with items.First() and now with cast (int)items[0] — semper fi, Apr 12 '16 at 10:09

score 1 · Answer 1 · edited May 23 '17 at 10:28

1

SqlDataReader reader = repo.ExecuteReader();
while (reader.reas.Read()) {
       rss.Id = (int)reader[0]; // should work

UPDATE

Try this

The result of ExecuteReader() method must be unboxed (looks like a cast, but this is unboxing) to the correct Type, before it can be assigned to an object or variable.

Are you asking why?

edited May 23 '17 at 10:28

Community

1
1

answered Apr 12 '16 at 09:48

Emanuele Greco

12,551
7
51
70

It says that: "cannot apply indexing with [] to an expression of type 'object'" – semper fi Apr 12 '16 at 09:57

score 1 · Answer 2 · answered Apr 12 '16 at 10:07

1

Try to cast it first, see below:

foreach (var items in repo.ExecuteReader()
   {
        var obj[] = (object[])items;
        rss.Id = obj[0];
        yield return obj;
   }

answered Apr 12 '16 at 10:07

Arnel Aves

87
5

score 0 · Accepted Answer · answered Apr 12 '16 at 10:14

0

Solution is provided by Hari Prasad, just need to change from

   foreach (var items in repo.ExecuteReader()) {}

to

   foreach (var object[] items in repo.ExecuteReader()

Now indexing and cast are working

answered Apr 12 '16 at 10:14

semper fi

727
3
17
32

how to parse data from array of objects

3 Answers3