how to get second record in linq to sql

Question

I have an exchange rate table. I need to get current rate and previous rate and then compare results.

I can get first record using FirstOrDefault.

When I am using ElementAtOrDefault, this error shows "The query operator 'ElementAtOrDefault' is not supported". How can I get the second record?

Answer 1

You can try this:

var query=data.Skip(1).Take(1);