payload: {"action":"created","issue":{"url":"https://api.github.com/repos/sqlkata/querybuilder/issues/317","repository_url":"https://api.github.com/repos/sqlkata/querybuilder","labels_url":"https://api.github.com/repos/sqlkata/querybuilder/issues/317/labels{/name}","comments_url":"https://api.github.com/repos/sqlkata/querybuilder/issues/317/comments","events_url":"https://api.github.com/repos/sqlkata/querybuilder/issues/317/events","html_url":"https://github.com/sqlkata/querybuilder/issues/317","id":522163690,"node_id":"MDU6SXNzdWU1MjIxNjM2OTA=","number":317,"title":"Overload InsertGetId to accept dictionary or real type with exclusion","user":{"login":"danielklecha","id":3874238,"node_id":"MDQ6VXNlcjM4NzQyMzg=","avatar_url":"https://avatars3.githubusercontent.com/u/3874238?v=4","gravatar_id":"","url":"https://api.github.com/users/danielklecha","html_url":"https://github.com/danielklecha","followers_url":"https://api.github.com/users/danielklecha/followers","following_url":"https://api.github.com/users/danielklecha/following{/other_user}","gists_url":"https://api.github.com/users/danielklecha/gists{/gist_id}","starred_url":"https://api.github.com/users/danielklecha/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/danielklecha/subscriptions","organizations_url":"https://api.github.com/users/danielklecha/orgs","repos_url":"https://api.github.com/users/danielklecha/repos","events_url":"https://api.github.com/users/danielklecha/events{/privacy}","received_events_url":"https://api.github.com/users/danielklecha/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":1,"created_at":"2019-11-13T11:54:43Z","updated_at":"2019-11-14T06:15:51Z","closed_at":"2019-11-14T06:15:51Z","author_association":"NONE","body":"Hello,\r\nI have a table in database with auto increment column.\r\nI want to insert into this table instance of my class, but skip this particular column and obtain new id.\r\nI saw that you added a method InsertGetId but I can't use my class because it contains this problematic column.\r\nIs there a solution for this or could you add new overload for this method?\r\nThanks for help!\r\n\r\nI can add class without id and derived class with id but it is not ideal solution.\r\n\r\nWorking part\r\n```c#\r\n//this is working with anonymous type\r\nvar newId = db.Query(\"MyTable\").InsertGetId<int>(new { Name = \"abcd\" });\r\n//this is working with instance but I can't obtain new id\r\nvar inst = new MyClass { Name = \"abcd\" };\r\nvar dict = typeof(MyClass)\r\n   .GetProperties()\r\n   .Where(x => x.Name != \"Id\")\r\n   .ToDictionary(x => x.Name, x => x.GetValue(inst));\r\nvar count = db.Query(\"MyTable\").Insert(dict);\r\n```\r\nProposed changes\r\n```c#\r\n//I can't do this - it should accept dictionary\r\nvar inst = new MyClass { Name = \"abcd\" };\r\nvar dict = typeof(MyClass)\r\n   .GetProperties()\r\n   .Where(x => x.Name != \"Id\")\r\n   .ToDictionary(x => x.Name, x => x.GetValue(inst));\r\nvar count = db.Query(\"MyTable\").Insert(dict);\r\nvar newId = db.Query(\"MyTable\").InsertGetId<int>(dict)\r\n//I can't do this - exclude column in InsertGetId (or IEnumerable<string> parameter)\r\nvar inst = new MyClass { Name = \"abcd\" };\r\nvar newId = db.Query(\"MyTable\").InsertGetId<int>(inst, \"Id\")\r\n```"},"comment":{"url":"https://api.github.com/repos/sqlkata/querybuilder/issues/comments/553742137","html_url":"https://github.com/sqlkata/querybuilder/issues/317#issuecomment-553742137","issue_url":"https://api.github.com/repos/sqlkata/querybuilder/issues/317","id":553742137,"node_id":"MDEyOklzc3VlQ29tbWVudDU1Mzc0MjEzNw==","user":{"login":"danielklecha","id":3874238,"node_id":"MDQ6VXNlcjM4NzQyMzg=","avatar_url":"https://avatars3.githubusercontent.com/u/3874238?v=4","gravatar_id":"","url":"https://api.github.com/users/danielklecha","html_url":"https://github.com/danielklecha","followers_url":"https://api.github.com/users/danielklecha/followers","following_url":"https://api.github.com/users/danielklecha/following{/other_user}","gists_url":"https://api.github.com/users/danielklecha/gists{/gist_id}","starred_url":"https://api.github.com/users/danielklecha/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/danielklecha/subscriptions","organizations_url":"https://api.github.com/users/danielklecha/orgs","repos_url":"https://api.github.com/users/danielklecha/repos","events_url":"https://api.github.com/users/danielklecha/events{/privacy}","received_events_url":"https://api.github.com/users/danielklecha/received_events","type":"User","site_admin":false},"created_at":"2019-11-14T06:15:51Z","updated_at":"2019-11-14T06:15:51Z","author_association":"NONE","body":"I had a problem to find it but I realized that this is in prerelease.\r\nAnyway, **it's working**.\r\nThanks for quick response!"}}
other: {"actor":{"display_login":"danielklecha"}}