C# LINQ from entity to 2D array

Question

I use entity framework, one entity called "interest rate", the Entity Set Name is “InterestRateSet”.

There are two properties, Time and Rate, both are double. The data for example, firstcolumn 0, 0.5, 1, secondcolumn 0, 0.01, 0.015

How can I get a 3row2column array using LINQ from InterestRateSet? Would someone show me the code example please? Thanks in advance!

Possible duplicate of c# linq return a multidimensional array from linq — layonez
– layonez, Commented May 8, 2016 at 18:57
Hello Layonez, thank you very much for you reply. I am really a beginner, would you show me an code example please? — Ruixin
– Ruixin, Commented May 8, 2016 at 19:00
Check my answer, made it using code from @Damith answer from post i mention — layonez
– layonez, Commented May 8, 2016 at 19:07

layonez · Accepted Answer · 2016-05-08 19:05:16Z

2

public string[,] GetInterestRates()
{
    var array  =(from ir in ctx.InterestRateSet                     
                 select new List<string>{ ir.Time.ToString() , ir.Rate.ToString()}).ToArray();

    return CreateRectangularArray(array);  
}


static T[,] CreateRectangularArray<T>(IList<T>[] arrays)
{
    // TODO: Validation and special-casing for arrays.Count == 0
    int minorLength = arrays[0].Count();
    T[,] ret = new T[arrays.Length, minorLength];
    for (int i = 0; i < arrays.Length; i++)
    {
        var array = arrays[i];
        if (array.Count != minorLength)
        {
            throw new ArgumentException
                ("All arrays must be the same length");
        }
        for (int j = 0; j < minorLength; j++)
        {
            ret[i, j] = array[j];
        }
    }
    return ret;
}

edited May 8, 2016 at 19:05

answered May 8, 2016 at 18:55

layonez

1,7851 gold badge16 silver badges20 bronze badges

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

3 Comments

Ruixin Over a year ago

Thank you, great help you are!

layonez Over a year ago

Typically, when something works, you should click on the little check box next to that answer to "mark it as the answer" - this will help your account over time, as it shows that your questions get answered when you ask them later ;)

Ruixin Over a year ago

Thank you, this is the first time I ask question on this website.

Collectives™ on Stack Overflow

C# LINQ from entity to 2D array

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related