{"action":"created","issue":{"url":"https://api.github.com/repos/CollaboratingPlatypus/PetaPoco/issues/188","repository_url":"https://api.github.com/repos/CollaboratingPlatypus/PetaPoco","labels_url":"https://api.github.com/repos/CollaboratingPlatypus/PetaPoco/issues/188/labels{/name}","comments_url":"https://api.github.com/repos/CollaboratingPlatypus/PetaPoco/issues/188/comments","events_url":"https://api.github.com/repos/CollaboratingPlatypus/PetaPoco/issues/188/events","html_url":"https://github.com/CollaboratingPlatypus/PetaPoco/issues/188","id":47951320,"number":188,"title":"Adding DateTime2 parameter ","user":{"login":"maxoizs","id":1402011,"avatar_url":"https://avatars1.githubusercontent.com/u/1402011?v=4","gravatar_id":"","url":"https://api.github.com/users/maxoizs","html_url":"https://github.com/maxoizs","followers_url":"https://api.github.com/users/maxoizs/followers","following_url":"https://api.github.com/users/maxoizs/following{/other_user}","gists_url":"https://api.github.com/users/maxoizs/gists{/gist_id}","starred_url":"https://api.github.com/users/maxoizs/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/maxoizs/subscriptions","organizations_url":"https://api.github.com/users/maxoizs/orgs","repos_url":"https://api.github.com/users/maxoizs/repos","events_url":"https://api.github.com/users/maxoizs/events{/privacy}","received_events_url":"https://api.github.com/users/maxoizs/received_events","type":"User","site_admin":false},"labels":[{"id":295126838,"url":"https://api.github.com/repos/CollaboratingPlatypus/PetaPoco/labels/enhancement","name":"enhancement","color":"84b6eb","default":true},{"id":295127007,"url":"https://api.github.com/repos/CollaboratingPlatypus/PetaPoco/labels/up-for-grabs","name":"up-for-grabs","color":"207de5","default":false}],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":4,"created_at":"2014-11-06T11:22:08Z","updated_at":"2018-04-18T23:15:44Z","closed_at":null,"author_association":"NONE","body":"Adding full DateTime with milliseconds in petepoco `AddParam` will be treated as `DateTime` which will loss the milliseconds part, and if I amend the if else case with \n\n``` c#\nelse if (item.GetType().Name == \"DateTime\")\n        {\n          p.DbType = DbType.DateTime2;\n          p.Value = item;\n        }\n```\n\nwill treat all `DateTime` parameters as `DateTime2` which ok in my case as I'm using `DateTime2` everywhere but it'll invalid the where clause for `DateTime` parameter if it's against `DateTime` only column. \n\nI wonder if it possible to determine the column type for the parameter ? \n"},"comment":{"url":"https://api.github.com/repos/CollaboratingPlatypus/PetaPoco/issues/comments/382558440","html_url":"https://github.com/CollaboratingPlatypus/PetaPoco/issues/188#issuecomment-382558440","issue_url":"https://api.github.com/repos/CollaboratingPlatypus/PetaPoco/issues/188","id":382558440,"user":{"login":"pleb","id":595869,"avatar_url":"https://avatars3.githubusercontent.com/u/595869?v=4","gravatar_id":"","url":"https://api.github.com/users/pleb","html_url":"https://github.com/pleb","followers_url":"https://api.github.com/users/pleb/followers","following_url":"https://api.github.com/users/pleb/following{/other_user}","gists_url":"https://api.github.com/users/pleb/gists{/gist_id}","starred_url":"https://api.github.com/users/pleb/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/pleb/subscriptions","organizations_url":"https://api.github.com/users/pleb/orgs","repos_url":"https://api.github.com/users/pleb/repos","events_url":"https://api.github.com/users/pleb/events{/privacy}","received_events_url":"https://api.github.com/users/pleb/received_events","type":"User","site_admin":false},"created_at":"2018-04-18T23:15:44Z","updated_at":"2018-04-18T23:15:44Z","author_association":"OWNER","body":"No worries mate. I should have some free time starting mid-year. Tickets, list this one, are on my list ;)"}}
{"actor":{"display_login":"pleb"}}