2 dimensional array to object in C# linq to sql [duplicate]

Question

I have a class

public class SomeClass {
            public string Name { get; set; }
            public string Age{get;set;}
        }

I have an array declared

string[,] testArray = { { "Vignesh", "25" },{"Raja","20"} };

I tried to convert the testArray to object of SomeClass[] using linq to sql But testArray.Select( is not coming. It says String[*,*] does not contain a definition for Select

var result = linqArray.Cast<string>().Select(x => x).ToArray();
            linqArray.Cast<string>()
 .Select(x => new SomeClass { Name =x, Age = x })
 .ToArray();

When I try this it is result is like shown below

enter image description here

I even tried type casting, which didnt work

SomeClass[] list = (SomeClass[])linqArray;

I think this needs some more clarity, I'm pretty sure the the second c# snippet isn't proper c# — Callum Linington
– Callum Linington, Commented Feb 23, 2015 at 11:11
Why do you use a mutli-dimentsional array in the first place? — Dirk
– Dirk, Commented Feb 23, 2015 at 11:14
@netwer: Often these questions are a cutdown version of the full code. In this case that might work but in reality I would guess that SomeClass probably has more properties on it. The nature of SomeClass is not important to the question, just the fact that it is in a multidimensional array. — Chris
– Chris, Commented Feb 23, 2015 at 11:32

Selman Genç · Accepted Answer · 2015-02-23 11:16:58Z

3

It's because multidimensional arrays are not IEnumerable<T>.First you need to turn your array into IEnumerable<T> using Cast or OfType method, then you can use Batch method:

array.Cast<string>()
 .Batch(2)
 .Select(x => new SomeClass { Name = x.First(), Age = x.Last()) })
 .ToArray();

Note you need to add a reference to MoreLINQ library to use Batch method.

answered Feb 23, 2015 at 11:16

Selman Genç

102k15 gold badges126 silver badges193 bronze badges

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

Collectives™ on Stack Overflow

2 dimensional array to object in C# linq to sql [duplicate]

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related