payload: {"action":"closed","issue":{"url":"https://api.github.com/repos/henkmollema/Dommel/issues/116","repository_url":"https://api.github.com/repos/henkmollema/Dommel","labels_url":"https://api.github.com/repos/henkmollema/Dommel/issues/116/labels{/name}","comments_url":"https://api.github.com/repos/henkmollema/Dommel/issues/116/comments","events_url":"https://api.github.com/repos/henkmollema/Dommel/issues/116/events","html_url":"https://github.com/henkmollema/Dommel/issues/116","id":441202533,"node_id":"MDU6SXNzdWU0NDEyMDI1MzM=","number":116,"title":"Problem with Left Join","user":{"login":"AlefHortela","id":33780380,"node_id":"MDQ6VXNlcjMzNzgwMzgw","avatar_url":"https://avatars0.githubusercontent.com/u/33780380?v=4","gravatar_id":"","url":"https://api.github.com/users/AlefHortela","html_url":"https://github.com/AlefHortela","followers_url":"https://api.github.com/users/AlefHortela/followers","following_url":"https://api.github.com/users/AlefHortela/following{/other_user}","gists_url":"https://api.github.com/users/AlefHortela/gists{/gist_id}","starred_url":"https://api.github.com/users/AlefHortela/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/AlefHortela/subscriptions","organizations_url":"https://api.github.com/users/AlefHortela/orgs","repos_url":"https://api.github.com/users/AlefHortela/repos","events_url":"https://api.github.com/users/AlefHortela/events{/privacy}","received_events_url":"https://api.github.com/users/AlefHortela/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":1,"created_at":"2019-05-07T12:22:09Z","updated_at":"2019-07-12T11:22:14Z","closed_at":"2019-07-12T11:22:14Z","author_association":"NONE","body":"Hello Henk, I've having a problem on \"left\" and \"inner\" joins on MultiMap, it's always returning a inner join and a need a left join on my query.\r\n\r\nhere is the code.\r\n\r\n```public new Station GetById(int id)\r\n        {\r\n            using (var db = new NpgsqlConnection(ConnectionString))\r\n            {\r\n                \r\n                var stationDictionary = new Dictionary<int, Station>();\r\n\r\n                var result = db.Get<Station, Package, Station>(id, (station, package) =>\r\n                {\r\n                    Station stationEntry;\r\n\r\n                    if (!stationDictionary.TryGetValue(station.Id, out stationEntry))\r\n                    {\r\n                        stationEntry = station;\r\n                        stationEntry.Packages = new List<Package>();\r\n                        stationDictionary.Add(id, stationEntry);\r\n                    }\r\n\r\n                    stationEntry.Packages.Add(package);\r\n                    return stationEntry;\r\n                });\r\n\r\n                return result;\r\n            }\r\n        }\r\n```\r\n\r\nhere is the entities \r\n\r\n``` public class Station\r\n    {\r\n        public int Id { get; set; }\r\n        public string Name { get; set; }\r\n        public string Desc { get; set; }\r\n\r\n        public ICollection<Package> Packages { get; set; } = new List<Package>();\r\n    }\r\n\r\n    public class Package\r\n    {\r\n        public int Id { get; set; }\r\n        public string Name { get; set; }\r\n        public string Desc { get; set; }\r\n\r\n        public int StationId { get; set; }\r\n        public Station Station { get; set; }\r\n    }\r\n```\r\nhere is the maps\r\n```        public PackageMap()\r\n        {\r\n            ToTable(\"package\");\r\n            Map(c => c.Id).ToColumn(\"id\").IsKey().IsIdentity();\r\n            Map(c => c.Name).ToColumn(\"nm_name\");\r\n            Map(c => c.Desc).ToColumn(\"nm_description\");\r\n            Map(c => c.StationId).ToColumn(\"id_station\");\r\n            Map(c => c.Station).Ignore();\r\n        }\r\n\r\n        public StationMap()\r\n        {\r\n            ToTable(\"station\");\r\n            Map(c => c.Id).ToColumn(\"id\").IsKey().IsIdentity();\r\n            Map(c => c.Name).ToColumn(\"nm_name\");\r\n            Map(c => c.Desc).ToColumn(\"nm_description\");\r\n        }\r\n```\r\n\r\nIt always returning me a inner join, I needed to put a \"?\" in StationId on Package to get a left join.\r\nprobably i'm making some mistakes on my code, could you help me?\r\n\r\nThanks and keep with the great work :)"}}
other: {"actor":{"display_login":"henkmollema"}}