Linq Help need to convert to Linq Object model from sql model

Question

I have the following Linq,

from x in Enumerable.Range(refx - 1, 3)
from y in Enumerable.Range(refy - 1, 3)
where
  (x >= 0 && y >= 0) &&
  (x < array.GetLength(0) && y < array.GetLength(1)) &&
  !(x == refx && y == refy)
select new Location(x,y)

I would like to have the same in the other Linq format

something like,

Enumerable.Range(refx-1,3)
.Select(x)
.Range(refy - 1, 3)
.Select(y)
.Where(x >= 0 && y >= 0) &&
      (x < array.GetLength(0) && y < array.GetLength(1)) &&
      !(x == refx && y == refy)
.Select new Location(x,y)

I know the above is wrong but i'd like the first in th second format, any help is greatly appriciated

also if someone is good at linq.js converting the first to linq.js would be super great!

Fwiw, ReSharper will do this for you automatically. – Kirk Woll Mar 14 '12 at 19:50 — Kirk Woll, Mar 14 '12 at 19:50
Thank you Kirk ReSharper did the Job :) – Mar 14 '12 at 20:12 — , Mar 14 '12 at 20:12

Joe · Answer 1 · 2012-03-14T20:11:37.073

0

This would be equivalent:

    var set = Enumerable.Range(refx - 1, 3)
            .Select(x => Enumerable.Range(refy - 1, 3)
                .Where(y => (x >= 0 && y >= 0) &&
                    (x < array.GetLength(0) && y < array.GetLength(1)) &&
                    !(x == refx && y == refy))
                .Select(y => new Location(x, y)))
            .SelectMany(x => x);

edited Mar 14 '12 at 20:11

answered Mar 14 '12 at 19:58

Joe

80,724
18
127
145

score 0 · Answer 2 · answered Mar 14 '12 at 20:00

0

I guess Zip is what you are looking for.

Enumerable.Range(refx - 1, 3).Zip(Enumerable.Range(refy - 1, 3),
    (x, y) => new Tuple<int, int>(x, y))
    .Where(t => (t.Item1 >= 0) && (t.Item2 <= 0)
    && (t.Item1 < array.GetLength(0)) && (t.Item2 < array.GetLength(1))
    && !((t.Item1 == refx) && (t.Item2 == refy)))
    .Select(t => new Location(t.Item1, t.Item2));

answered Mar 14 '12 at 20:00

easyCIS

1

Is there Obfuscated C# Code Contest ? – L.B Mar 14 '12 at 20:09

Linq Help need to convert to Linq Object model from sql model

2 Answers2