René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"Feature Request: Handle DBNull as $null","articleBody":"# Summary of the new feature/enhancement\r\n\r\nAs a scripter who has recently been working with databases quite a bit, it's become a headache to check constantly for [DBNull]::Value. It has a tendency to \"leak\" outside of my database code, and I need to start checking for DbNull values all over the rest of my code as well.\r\n\r\nPowerShell already handles both $null and an empty string in the same manner. Can it also treat [DBNull]::Value as $null for purposes of conditionals?\r\n\r\nHere is a contrived example of what I mean,\r\n\r\n```powershell\r\n$myVar = $null\r\nif (-not $myVar) {\r\n  # This will run\r\n  'MyVar is null'\r\n}\r\n\r\n$myVar = ''\r\nif (-not $myVar) {\r\n  # This will also run\r\n  'MyVar is null'\r\n}\r\n\r\n$myVar = [DbNull]::Value\r\nif (-not $myVar) {\r\n  # This will not run\r\n  'MyVar is null'\r\n}\r\n```\r\n\r\nThe last case is what I'd like to see changed - I'd like that to be handled in the same way as the first two cases.","author":{"url":"https://github.com/replicaJunction","@type":"Person","name":"replicaJunction"},"datePublished":"2019-05-08T14:14:50.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":8},"url":"https://github.com/9561/PowerShell/issues/9561"}