Skip() with parameters problem

Discussion of open issues, suggestions and bugs regarding Entity Framework support in ADO.NET Data providers
Post Reply
tompolth
Posts: 6
Joined: Mon 29 Dec 2008 22:49
Location: Spain

Skip() with parameters problem

Post by tompolth » Thu 30 Jul 2009 07:29

Good morning:

At first, sorry for my English :oops:

Yesterday I´ve updated Devart DotConnect for Oracle Pro to version 5.25 from 5.20. Before our applications run perfectly, but now we´ve detect a problem with next code that before run well:

Code: Select all

string keyOrder ="it.numAtes DESC";

return cons.Skip(keyOrder, "@skip", new ObjectParameter("skip", pageIndex* pageCount))
                .Take(PageCount).ToList();
In runtime, above code throws an inner expception:

{"ORA-00936: falta una expresión"}

using the function toTraceString() I obtain the sql statment that seems to have problem with "skip" parameter. I don´t understant because now isn´t work. In previous version worked fine.

Thanks

AndreyR
Devart Team
Posts: 2919
Joined: Mon 07 Jul 2008 13:16

Post by AndreyR » Thu 30 Jul 2009 08:26

Thank you for your inquiry, we have already found and fixed the problem.
The fix will be included in the next build, we plan to release it in a week or so.

tompolth
Posts: 6
Joined: Mon 29 Dec 2008 22:49
Location: Spain

Post by tompolth » Thu 30 Jul 2009 08:52

Thank you for your rapid response. It will wait impatiently for the new version since it is essential for the correct functioning of our applications

Greetings

Post Reply