When I use a group by, if I want to use an order by on group items subquery, the order by is ignored. Is this a bug? Should I write my query differently?
new MyEntity(session) { Text = "test 1", Text2 = "2" };
new MyEntity(session) { Text = "test 1", Text2 = "3" };
new MyEntity(session) { Text = "test 1", Text2 = "1" };
new MyEntity(session) { Text = "test 2", Text2 = "2" };
new MyEntity(session) { Text = "test 2", Text2 = "3" };
new MyEntity(session) { Text = "test 2", Text2 = "1" };
Query:
var query = from e in session.Query.All<MyEntity>()
group e by e.Text into g
select new { Key = g.Key, First = g.OrderBy(e => e.Text2).Select(e => e.Text2).FirstOrDefault() };
Result :
I was expecting :
asked
Jan 26 '12 at 03:07
olorin
358●87●87●92
Hello olorin,
Thanks for submitting the case, right now we are in the process of fixing it. It is expected to be done shortly.