EF Core Joining

DataModel.cs

public class TestDbContext : DbContext
{
    public DbSet<Child> Children { get; set; }
    public DbSet<Parent> Parents { get; set; }

    protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
    {
        base.OnConfiguring(optionsBuilder);

        optionsBuilder.UseSqlServer("Data Source=.;Initial Catalog=ConsoleApp12;Integrated Security=true;");
    }
}

public class Parent
{
    public int Id { get; set; }
    public string Name { get; set; }
    public List<Child> Children { get; set; }
}

public class Child
{
    public int Id { get; set; }
    public Parent Parent { get; set; }
    public int ParentId { get; set; }
    public string Name { get; set; }
}

Program.cs

public class Program
{
    public static void Main(string[] args)
    {
        using (var context = new TestDbContext())
        {
            context.Parents.Add(new Parent
            {
                Children = new List<Child>
                {
                    new Child { Name = "Ipsum" },
                    new Child { Name = "Dolor" }
                },
                Name = "Lorem"
            });

            context.SaveChanges();
        }

        using (var context = new TestDbContext())
        {
            context.Parents.Where(parent => parent.Name == "Lorem")
                .SelectMany(parent => parent.Children)
                .Select(child => new Flat
                {
                    ChildId = child.Id,
                    ChildName = child.Name,
                    ParentId = child.ParentId,
                    ParentName = child.Parent.Name
                })
                .ToList();
        }
    }
}

public class Flat
{
    public int ParentId { get; set; }
    public string ParentName { get; set; }
    public int ChildId { get; set; }
    public string ChildName { get; set; }
}

project.json

{
    "version": "1.0.0-*",
    "buildOptions": {
        "emitEntryPoint": true
    },

    "dependencies": {
        "Microsoft.NETCore.App": {
            "type": "platform",
            "version": "1.0.1"
        },
        "Microsoft.EntityFrameworkCore": "1.0.1",
        "Microsoft.EntityFrameworkCore.Design": "1.0.0-preview2-final",
        "Microsoft.EntityFrameworkCore.SqlServer": "1.0.1"
    },

    "tools": {
        "Microsoft.EntityFrameworkCore.Tools": "1.0.0-preview2-final"
    },

    "frameworks": {
        "netcoreapp1.0": {
            "imports": "dnxcore50"
        }
    }
}

Query.sql

SELECT [parent.Children].[Id], [parent.Children].[Name], [parent.Children].[ParentId], [parent.Children.Parent].[Name]
FROM [Parents] AS [parent]
INNER JOIN [Children] AS [parent.Children] ON [parent].[Id] = [parent.Children].[ParentId]
INNER JOIN [Parents] AS [parent.Children.Parent] ON [parent.Children].[ParentId] = [parent.Children.Parent].[Id]
WHERE [parent].[Name] = N'Lorem'