{"action":"closed","issue":{"url":"https://api.github.com/repos/aspnet/EntityFramework/issues/6392","repository_url":"https://api.github.com/repos/aspnet/EntityFramework","labels_url":"https://api.github.com/repos/aspnet/EntityFramework/issues/6392/labels{/name}","comments_url":"https://api.github.com/repos/aspnet/EntityFramework/issues/6392/comments","events_url":"https://api.github.com/repos/aspnet/EntityFramework/issues/6392/events","html_url":"https://github.com/aspnet/EntityFramework/issues/6392","id":172670446,"number":6392,"title":"Using FromSql and Include seems to render an inner join","user":{"login":"johanskoldekrans","id":18699147,"avatar_url":"https://avatars.githubusercontent.com/u/18699147?v=3","gravatar_id":"","url":"https://api.github.com/users/johanskoldekrans","html_url":"https://github.com/johanskoldekrans","followers_url":"https://api.github.com/users/johanskoldekrans/followers","following_url":"https://api.github.com/users/johanskoldekrans/following{/other_user}","gists_url":"https://api.github.com/users/johanskoldekrans/gists{/gist_id}","starred_url":"https://api.github.com/users/johanskoldekrans/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/johanskoldekrans/subscriptions","organizations_url":"https://api.github.com/users/johanskoldekrans/orgs","repos_url":"https://api.github.com/users/johanskoldekrans/repos","events_url":"https://api.github.com/users/johanskoldekrans/events{/privacy}","received_events_url":"https://api.github.com/users/johanskoldekrans/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/aspnet/EntityFramework/labels/closed-by-design","name":"closed-by-design","color":"777777"}],"state":"closed","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":7,"created_at":"2016-08-23T11:01:19Z","updated_at":"2016-08-25T23:44:57Z","closed_at":"2016-08-25T23:44:57Z","body":"This results in 10 returned rows:\r\n\r\n``` C#\r\ncontext.SomeTable.FromSql(\"Select top 10 * from SomeTable\").ToList();\r\n```\r\n\r\nIf I want to use a navigation property and include another table I seem to get an inner join that only returns rows that are in table SomeData:\r\n\r\n``` C#\r\ncontext.SomeTable.FromSql(\"Select top 10 * from SomeTable\").Include(f => f.SomeData).ToList();\r\n```\r\n\r\nIs this behavior as designed? Can I somehow make it do a left join without rewriting it using the from-syntax?\r\n\r\nEF Core version: 1.1.0-alpha1\r\nOperating system: \r\nVisual Studio version: VS 2015"}}
{"actor":{"display_login":"divega"}}