{"id":4015,"date":"2020-09-04T13:27:50","date_gmt":"2020-09-04T12:27:50","guid":{"rendered":"https:\/\/solidt.eu\/site\/?p=4015"},"modified":"2022-07-25T08:32:08","modified_gmt":"2022-07-25T07:32:08","slug":"c-get-sql-parameter","status":"publish","type":"post","link":"https:\/\/solidt.eu\/site\/c-get-sql-parameter\/","title":{"rendered":"C# Get SQL parameter"},"content":{"rendered":"\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"csharp\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">public static string GetSqlParam(object value)\n{\n\tif (value == null) return \"NULL\";\n\tif (value is bool b) return b ? \"1\" : \"0\"; \/\/ OR: SQL dialect: TRUE, FALSE\n\tif (value is Enum) return ((int)value).ToString();\n\tif (IsNumeric(value.GetType())) return value.ToString();\n\tif (value is DateTime d) return $\"'{d.ToString(\"s\", System.Globalization.CultureInfo.InvariantCulture)}'\";\n\treturn \"'\" + value.ToString().Replace(\"'\", \"''\") + \"'\";\n}<\/pre>\n\n\n\n<p>IsNumeric implementation: <a href=\"https:\/\/solidt.eu\/site\/c-isnumeric\/\">https:\/\/solidt.eu\/site\/c-isnumeric\/<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>IsNumeric implementation: https:\/\/solidt.eu\/site\/c-isnumeric\/<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"inline_featured_image":false,"footnotes":""},"categories":[6,4,1],"tags":[],"class_list":["post-4015","post","type-post","status-publish","format-standard","hentry","category-dotnet","category-programming","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/solidt.eu\/site\/wp-json\/wp\/v2\/posts\/4015","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/solidt.eu\/site\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/solidt.eu\/site\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/solidt.eu\/site\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/solidt.eu\/site\/wp-json\/wp\/v2\/comments?post=4015"}],"version-history":[{"count":5,"href":"https:\/\/solidt.eu\/site\/wp-json\/wp\/v2\/posts\/4015\/revisions"}],"predecessor-version":[{"id":4830,"href":"https:\/\/solidt.eu\/site\/wp-json\/wp\/v2\/posts\/4015\/revisions\/4830"}],"wp:attachment":[{"href":"https:\/\/solidt.eu\/site\/wp-json\/wp\/v2\/media?parent=4015"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/solidt.eu\/site\/wp-json\/wp\/v2\/categories?post=4015"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/solidt.eu\/site\/wp-json\/wp\/v2\/tags?post=4015"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}