Linq select specific last records

Question

I new developer for linq and sql server. I know oracle and pl/sql how I can write this query in linq Oracle :

select * from (select * from table order by createDate) where rownum<500

Even if new.... you should show what you have tried... – Gilad Green Sep 12 '17 at 13:14 — Gilad Green, Sep 12 '17 at 13:14

score 0 · Accepted Answer · answered Sep 12 '17 at 13:10

0

var query = db.Table.OrderBy(x => x.createDate).Take(499);

answered Sep 12 '17 at 13:10

Tim Schmelter

2

@alettin - if Tim has solved your problem, be a pal and accept his answer :) – Brett Sep 12 '17 at 13:39
1

@alettin: What Brett wanted to tell you is, there is a check mark beside the answer. Look [here](https://meta.stackexchange.com/questions/5234/how-does-accepting-an-answer-work) – Tim Schmelter Sep 12 '17 at 13:56

1 Answers1