Get ROWNUM

Dominik · Post by **Dominik** » Wed 29 Dec 2010 08:48

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.

AndreyR · Post by **AndreyR** » Wed 29 Dec 2010 13:43

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