After install version 5.0.16.0, I found the serious error ORA-01036: illegal variable name/number when paging query result.
1. Create any table.
2. Generate code C#.
3. Test:
Work:
Code: Select all
DataContext db = new DataContext();
var x = db.Articles.Take(10).AsEnumerable();
Code: Select all
DataContext db = new DataContext();
var x = db.Articles.Skip(5).AsEnumerable();
Code: Select all
DataContext db = new DataContext();
var x = db.Articles.Skip(5).Take(10).AsEnumerable();
Thanks.