Hello.

How can I query RowNumber with Entity Framework? For example:

        var result = data.Users
            .OrderByDescending("Birthday")
            .ThenBy("LastName")
            .ThenBy("FirstName")
            .Select(u =>
                        {
                            RowNumber = ???,
                            u.FirstName,
                            u.LastName
                        });

I want to implement paging for my grid, but I cannot solve problem with finding page with needed user.

I'm using EF4.0. Select method with index(http://msdn.microsoft.com/en-us/vcsharp/aa336758.aspx#SelectIndexed) not works with EF.

May be there is another way to implement this?