Question

Hi,

When i want to use OrderBy() with Skip() and Take() methods OrderBy is ommited and it's not included in SQL Query. How can I solve the problem?

Regards, Karol Wojtaszek

Answer 1

0	I'm 100% sure this shouldn't happen - there are multiple tests for this case. Can you provide an exact LINQ query? answered Feb 23 '11 at 07:32 Alex Yakunin 2971●4●4●12 edited Feb 23 '11 at 07:32

Answer 2

0

int x = (APage - 1) * APerPage;
var ex = _session.Query.All<Platnik>()
  .Where(p => p.Firma == FirmaFilter)
  .OrderBy(p => p.Dane.Indeks)
  .Skip(() => x)
  .Take(() => APerPage);

answered Feb 23 '11 at 07:38

Karol Wojtaszek
40●2●2●4

edited Feb 23 '11 at 13:37

Alex Yakunin
2971●4●4●12

Even if I change the order it doesn't work:

_session.Query.All<Platnik>()
.Where(p => p.Firma == FirmaFilter)
.Take(() => APerPage)
.OrderBy(p => p.Dane.Indeks);

(Feb 23 '11 at 07:44) Karol Wojtaszek

Changing the order definitely shouldn't help here.

Could you also add executed SQL for this query (the first one)? You can use SQL profiler or DO4 logging to get it.

(Feb 23 '11 at 13:36) Alex Yakunin

I've tried to turn on logging with log4net and couldn't do it. I've added dlls and added to app.config: http://pastebin.com/KP5d4QFW

(Feb 24 '11 at 15:55) Karol Wojtaszek

Hello Karol,

Which version of DataObjects.Net you are using? It could be 4.3.x or 4.4.

(Feb 25 '11 at 11:25) Dmitri Maximov

It's lastest 4.4 build

(Feb 25 '11 at 14:47) Karol Wojtaszek

Karol, I've updated the configuration file you posted, now it uses the internal logging mechanism, which is simpler.

Could you please try once more? Thanks.

(Feb 25 '11 at 15:16) Dmitri Maximov

Problem is connected with dot and subproperties (p.Dane is a structure). When I OrderBy with e.g. p.Id, it's ordering correctly

(Feb 26 '11 at 04:47) Karol Wojtaszek

OK, we'll check this scenario.

(Mar 01 '11 at 05:35) Dmitri Maximov

Hello Karol,

Unfortunately, we failed to reproduce the issue. Could you send us the test case? The e-mail is: support [at] x-tensive.com.

Thanks.

(Mar 05 '11 at 08:34) Dmitri Maximov

Subscription:

Related questions