{"action":"created","issue":{"url":"https://api.github.com/repos/NLog/NLog/issues/293","labels_url":"https://api.github.com/repos/NLog/NLog/issues/293/labels{/name}","comments_url":"https://api.github.com/repos/NLog/NLog/issues/293/comments","events_url":"https://api.github.com/repos/NLog/NLog/issues/293/events","html_url":"https://github.com/NLog/NLog/issues/293","id":25109485,"number":293,"title":"Possible to insert a null into a database column, using Configuration API?","user":{"login":"jacquibo","id":5796126,"avatar_url":"https://avatars.githubusercontent.com/u/5796126?v=3","gravatar_id":"","url":"https://api.github.com/users/jacquibo","html_url":"https://github.com/jacquibo","followers_url":"https://api.github.com/users/jacquibo/followers","following_url":"https://api.github.com/users/jacquibo/following{/other_user}","gists_url":"https://api.github.com/users/jacquibo/gists{/gist_id}","starred_url":"https://api.github.com/users/jacquibo/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jacquibo/subscriptions","organizations_url":"https://api.github.com/users/jacquibo/orgs","repos_url":"https://api.github.com/users/jacquibo/repos","events_url":"https://api.github.com/users/jacquibo/events{/privacy}","received_events_url":"https://api.github.com/users/jacquibo/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/NLog/NLog/labels/feature","name":"feature","color":"02e10c"}],"state":"open","locked":false,"assignee":{"login":"304NotModified","id":5808377,"avatar_url":"https://avatars.githubusercontent.com/u/5808377?v=3","gravatar_id":"","url":"https://api.github.com/users/304NotModified","html_url":"https://github.com/304NotModified","followers_url":"https://api.github.com/users/304NotModified/followers","following_url":"https://api.github.com/users/304NotModified/following{/other_user}","gists_url":"https://api.github.com/users/304NotModified/gists{/gist_id}","starred_url":"https://api.github.com/users/304NotModified/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/304NotModified/subscriptions","organizations_url":"https://api.github.com/users/304NotModified/orgs","repos_url":"https://api.github.com/users/304NotModified/repos","events_url":"https://api.github.com/users/304NotModified/events{/privacy}","received_events_url":"https://api.github.com/users/304NotModified/received_events","type":"User","site_admin":false},"milestone":null,"comments":6,"created_at":"2014-01-06T15:56:23Z","updated_at":"2015-03-26T23:03:38Z","closed_at":null,"body":"I don't seem to be able to find a way to insert a null into a database column, using the Configuration API. I have some columns that are not always required, so for some logging will be nulls.\r\n\r\nThe only way I have found to do this is to use a stored procedure, and pass empty strings to it for any nulls. The stored procedure then puts in null whenever there is an empty string.\r\n\r\nCould this feature be added in some way? e.g.\r\n\r\n```\r\nvar param = new DatabaseParameterInfo();\r\nparam.Name = \"foo\";\r\nparam.Layout = null;\r\ntarget.Parameters.Add(param);\r\n```"},"comment":{"url":"https://api.github.com/repos/NLog/NLog/issues/comments/86749124","html_url":"https://github.com/NLog/NLog/issues/293#issuecomment-86749124","issue_url":"https://api.github.com/repos/NLog/NLog/issues/293","id":86749124,"user":{"login":"304NotModified","id":5808377,"avatar_url":"https://avatars.githubusercontent.com/u/5808377?v=3","gravatar_id":"","url":"https://api.github.com/users/304NotModified","html_url":"https://github.com/304NotModified","followers_url":"https://api.github.com/users/304NotModified/followers","following_url":"https://api.github.com/users/304NotModified/following{/other_user}","gists_url":"https://api.github.com/users/304NotModified/gists{/gist_id}","starred_url":"https://api.github.com/users/304NotModified/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/304NotModified/subscriptions","organizations_url":"https://api.github.com/users/304NotModified/orgs","repos_url":"https://api.github.com/users/304NotModified/repos","events_url":"https://api.github.com/users/304NotModified/events{/privacy}","received_events_url":"https://api.github.com/users/304NotModified/received_events","type":"User","site_admin":false},"created_at":"2015-03-26T23:03:38Z","updated_at":"2015-03-26T23:03:38Z","body":"Yes, thanks for the info.\r\n\r\nNote: Also SQL Server has a [`NULLIF`](https://msdn.microsoft.com/en-us/library/ms177562.aspx)"}}