Query: Include with OrderBy with Skip(0) cause OrderBy to be ignored

[303248153]

Use Include with OrderBy with Skip(0) will cause OrderBy gets ignored.

Steps to reproduce

This is the standalone project for reproduce the problem
EFExample.zip

The main code is as follows

using (var context = new ExampleContext())
{
    var authors = context.Set<Author>();
    Console.WriteLine("order by age");
    var result = authors
        .Include(a => a.Articles)
        .OrderBy(a => a.Age).Skip(0).Take(100).ToList();
    foreach (var author in result)
    {
        Console.WriteLine(author.Name);
    }
    Console.WriteLine();

    Console.WriteLine("order by age descending");
    result = authors
        .Include(a => a.Articles)
        .OrderByDescending(a => a.Age).Skip(0).Take(100).ToList();
    foreach (var author in result)
    {
        Console.WriteLine(author.Name);
    }
    Console.ReadLine();
}

The output is

order by age
Steve
John

order by age descending
Steve
John

The issue

EF generated following SQL

exec sp_executesql N'SELECT [t].[Id], [t].[Age], [t].[CreateTime], [t].[Deleted], [t].[Name], [t].[UpdateTime]
FROM (
    SELECT [a].[Id], [a].[Age], [a].[CreateTime], [a].[Deleted], [a].[Name], [a].[UpdateTime], ROW_NUMBER() OVER(ORDER BY [a].[Age]) AS [__RowNumber__]
    FROM [Author] AS [a]
) AS [t]
WHERE ([t].[__RowNumber__] > @__p_0) AND ([t].[__RowNumber__] <= (@__p_0 + @__p_1))
ORDER BY [t].[Id]',N'@__p_0 int,@__p_1 int',@__p_0=0,@__p_1=100
go

Further technical details

EF Core version: 1.0.1
Operating system: Windows 8.1
Visual Studio version: VS2015 update 3