Page 1 of 1

Get ROWNUM

Posted: Wed 29 Dec 2010 08:48
by Dominik
Hi,

Is there any way to get ROWNUM and add it to my EDMX entity model as a property field using IQueryable sentences?

Thanks in advance,

Dominik.

Posted: Wed 29 Dec 2010 13:43
by AndreyR
You can create a View in your Oracle database with the following code:

Code: Select all

select deptno, dname, loc, rownum from dept
In case you don't want or don't have a permission to create views in database, you can create a Defining Query in the model (Devart Entity model->Model Explorer->right-click the Model.Store node).
If you are using Microsoft Entity models, please take a look at this article