{"id":115,"date":"2016-03-19T11:37:38","date_gmt":"2016-03-19T10:37:38","guid":{"rendered":"https:\/\/solidt.eu\/blog\/?p=115"},"modified":"2016-03-19T11:37:38","modified_gmt":"2016-03-19T10:37:38","slug":"c-building-an-sql-list","status":"publish","type":"post","link":"https:\/\/solidt.eu\/site\/c-building-an-sql-list\/","title":{"rendered":"C# Building an SQL list"},"content":{"rendered":"<pre lang=\"c#\">\r\npublic static string GetSqlList<T>(IEnumerable<T> list)\r\n{\r\n\tStringBuilder sb = new StringBuilder();\r\n\r\n\tforeach (T item in list)\r\n\t{\r\n\t\tif (item != null && item.ToString() != \"\")\r\n\t\t{\r\n\t\t\tif (sb.Length != 0)\r\n\t\t\t\tsb.Append(\", \");\r\n\t\t\tsb.Append(\"'\");\r\n\t\t\tsb.Append(item.ToString().Replace(\"'\", \"''\"));\r\n\t\t\tsb.Append(\"'\");\r\n\t\t}\r\n\t}\r\n\treturn sb.ToString();\r\n}\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>public static string GetSqlList(IEnumerable list) { StringBuilder sb = new StringBuilder(); foreach (T item in list) { if (item != null &#038;&#038; item.ToString() != &#8220;&#8221;) { if (sb.Length != 0) sb.Append(&#8220;, &#8220;); sb.Append(&#8220;&#8216;&#8221;); sb.Append(item.ToString().Replace(&#8220;&#8216;&#8221;, &#8220;&#8221;&#8221;)); sb.Append(&#8220;&#8216;&#8221;); } } return sb.ToString(); }<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"inline_featured_image":false,"footnotes":""},"categories":[6],"tags":[],"class_list":["post-115","post","type-post","status-publish","format-standard","hentry","category-dotnet"],"_links":{"self":[{"href":"https:\/\/solidt.eu\/site\/wp-json\/wp\/v2\/posts\/115","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=115"}],"version-history":[{"count":1,"href":"https:\/\/solidt.eu\/site\/wp-json\/wp\/v2\/posts\/115\/revisions"}],"predecessor-version":[{"id":116,"href":"https:\/\/solidt.eu\/site\/wp-json\/wp\/v2\/posts\/115\/revisions\/116"}],"wp:attachment":[{"href":"https:\/\/solidt.eu\/site\/wp-json\/wp\/v2\/media?parent=115"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/solidt.eu\/site\/wp-json\/wp\/v2\/categories?post=115"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/solidt.eu\/site\/wp-json\/wp\/v2\/tags?post=115"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}