Getting a JSON array from a linq on c#

Question

I'm trying to output data like this:

[[...],[...],[...],[...]]

But my query gives me this result:

[{...},{...},{...},{...}]

Here is my query:

  var result = (from c in displayedCompanies
                          group c by new { c.CodigoDeVenta } into s
                          select new{
                             ID = Convert.ToString(i++),
                             s.Key.CodigoDeVenta,
                             TotalInv = s.Sum(x => x.Inventario)
                             }).ToArray();

I've tried some options like the following but it's wrong:

  var result = (from c in displayedCompanies
                          group c by new { c.CodigoDeVenta } into s
                          select new [] {
                             ID = Convert.ToString(i++),
                             s.Key.CodigoDeVenta,
                             TotalInv = s.Sum(x => x.Inventario)
                             }).ToArray();

Note that the diference is the [] in select new []. I used to have a query before I implemented the "group by" that worked correctly, but after I added the group by this does not work anymore.

Thanks!

I would try select new List<object>(){Convert.ToString(i++),s.Key.CodigoDeVenta,s.Sum(x => x.Inventario)} — Eser
– Eser, Commented Feb 28, 2016 at 0:03

clarkitect · Accepted Answer · 2016-02-28 04:04:22Z

1

Setting aside the grouping, focusing only on the syntax, your anonymous array (new [] {...}) should be fine.

However, it appears that you're trying to assign Id = and TotalInv = which looks like a leftover from the previous revision where you were selecting an anonymous object.

So, instead, you should be able to drop the member identifiers and select just the values you want in the child arrays:

select new [] {
    Convert.ToString(i++),
    s.Key.CodigoDeVenta,
    s.Sum(x => x.Inventario)
}

answered Feb 28, 2016 at 4:04

clarkitect

1,73014 silver badges23 bronze badges

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

Collectives™ on Stack Overflow

Getting a JSON array from a linq on c#

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related