https://achadwick.com/DeveloperBlog

1<!DOCTYPE html><html><head><meta charSet="utf-8"/><title>Allan Chadwick Developer Blog</title><meta content="width=device-width, initial-scale=1.0" name="viewport"/><meta content="Allan Chadwick" name="author"/><meta content="The blog of Allan Chadwick C# Sql Javascript" name="description"/><meta property="og:title" content="Allan Chadwick Developer Blog"/><meta property="og:description" content="The blog of Allan Chadwick C# Sql Javascript"/><meta property="og:type" content="blog"/><meta property="og:image"/><meta name="robots" content="index, follow"/><meta name="next-head-count" content="10"/><link rel="preload" href="/_next/static/css/bc712233787fb57439c7.css" as="style"/><link rel="stylesheet" href="/_next/static/css/bc712233787fb57439c7.css" data-n-g=""/><link rel="preload" href="/_next/static/css/654ad86544e5f1e056bc.css" as="style"/><link rel="stylesheet" href="/_next/static/css/654ad86544e5f1e056bc.css" data-n-p=""/><noscript data-n-css=""></noscript><link rel="preload" href="/_next/static/chunks/webpack-1fcfb52dd685e6ffbb87.js" as="script"/><link rel="preload" href="/_next/static/chunks/framework-12b998e3f139f1eb798c.js" as="script"/><link rel="preload" href="/_next/static/chunks/commons-ce1eb193d2064abecece.js" as="script"/><link rel="preload" href="/_next/static/chunks/main-910ac74a12454b8967cd.js" as="script"/><link rel="preload" href="/_next/static/chunks/pages/_app-2755b7cda550b9b0ca76.js" as="script"/><link rel="preload" href="/_next/static/chunks/a9a7754c-2e9969d04ec4ace6c1fe.js" as="script"/><link rel="preload" href="/_next/static/chunks/75fc9c18-9942a58048f91d946457.js" as="script"/><link rel="preload" href="/_next/static/chunks/485-bd9cde59bf2f2502a3e6.js" as="script"/><link rel="preload" href="/_next/static/chunks/762-a6508b74925918f1abd8.js" as="script"/><link rel="preload" href="/_next/static/chunks/pages/DeveloperBlog-fe3e88c4623d3f70e103.js" as="script"/></head><body><div id="__next"><div class="mr-8"><div style="min-height:48px" class="flex flex-wrap px-2 mb-2 items-center bg-gradient-to-b from-gray-600 via-gray-700 to-gray-600 text-gray-200 justify-between rounded-md"><div><h1 class="hover:text-gray-400 "><a href="/">Allan Chadwick</a></h1></div><div class="md:hidden hover:text-gray-400 "><div class="hamburger-react" role="button" style="cursor:pointer;height:48px;position:relative;transition:0.4s cubic-bezier(0, 0, 0, 1);user-select:none;width:48px;outline:none;transform:none" tabindex="0"><div style="background:currentColor;height:3px;left:8px;position:absolute;width:32px;top:13px;transition:0.4s cubic-bezier(0, 0, 0, 1);transform:none"></div><div style="background:currentColor;height:3px;left:8px;position:absolute;width:32px;top:23px;transition:0.4s cubic-bezier(0, 0, 0, 1);transform:none"></div><div style="background:currentColor;height:3px;left:8px;position:absolute;width:32px;top:33px;transition:0.4s cubic-bezier(0, 0, 0, 1);transform:none"></div></div></div><div class="nav-hide"><a href="/DeveloperBlog" class="px-2 py-2 hover:text-gray-400">Code</a><a href="/MusicBlog" class="px-2 py-2 hover:text-gray-400">Music</a><a href="/ElectronicsBlog" class="px-2 py-2 hover:text-gray-400">Electronics</a><a href="https://github.com/thedev6" aria-label="Link to Github Account" target="_blank" class="px-2 py-2 hover:text-gray-400"><svg aria-hidden="true" focusable="false" data-prefix="fab" data-icon="github" class="svg-inline--fa fa-github fa-w-16 fa-2x " role="img" xmlns="http://www.w3.org/2000/svg" viewBox="0 0 496 512"><path fill="currentColor" d="M165.9 397.4c0 2-2.3 3.6-5.2 3.6-3.3.3-5.6-1.3-5.6-3.6 0-2 2.3-3.6 5.2-3.6 3-.3 5.6 1.3 5.6 3.6zm-31.1-4.5c-.7 2 1.3 4.3 4.3 4.9 2.6 1 5.6 0 6.2-2s-1.3-4.3-4.3-5.2c-2.6-.7-5.5.3-6.2 2.3zm44.2-1.7c-2.9.7-4.9 2.6-4.6 4.9.3 2 2.9 3.3 5.9 2.6 2.9-.7 4.9-2.6 4.6-4.6-.3-1.9-3-3.2-5.9-2.9zM244.8 8C106.1 8 0 113.3 0 252c0 110.9 69.8 205.8 169.5 239.2 12.8 2.3 17.3-5.6 17.3-12.1 0-6.2-.3-40.4-.3-61.4 0 0-70 15-84.7-29.8 0 0-11.4-29.1-27.8-36.6 0 0-22.9-15.7 1.6-15.4 0 0 24.9 2 38.6 25.8 21.9 38.6 58.6 27.5 72.9 20.9 2.3-16 8.8-27.1 16-33.7-55.9-6.2-112.3-14.3-112.3-110.5 0-27.5 7.6-41.3 23.6-58.9-2.6-6.5-11.1-33.3 2.6-67.9 20.9-6.5 69 27 69 27 20-5.6 41.5-8.5 62.8-8.5s42.8 2.9 62.8 8.5c0 0 48.1-33.6 69-27 13.7 34.7 5.2 61.4 2.6 67.9 16 17.7 25.8 31.5 25.8 58.9 0 96.5-58.9 104.2-114.8 110.5 9.2 7.9 17 22.9 17 46.4 0 33.7-.3 75.4-.3 83.6 0 6.5 4.6 14.4 17.3 12.1C428.2 457.8 496 362.9 496 252 496 113.3 383.5 8 244.8 8zM97.2 352.9c-1.3 1-1 3.3.7 5.2 1.6 1.6 3.9 2.3 5.2 1 1.3-1 1-3.3-.7-5.2-1.6-1.6-3.9-2.3-5.2-1zm-10.8-8.1c-.7 1.3.3 2.9 2.3 3.9 1.6 1 3.6.7 4.3-.7.7-1.3-.3-2.9-2.3-3.9-2-.6-3.6-.3-4.3.7zm32.4 35.6c-1.6 1.3-1 4.3 1.3 6.2 2.3 2.3 5.2 2.6 6.5 1 1.3-1.3.7-4.3-1.3-6.2-2.2-2.3-5.2-2.6-6.5-1zm-11.4-14.7c-1.6 1-1.6 3.6 0 5.9 1.6 2.3 4.3 3.3 5.6 2.3 1.6-1.3 1.6-3.9 0-6.2-1.4-2.3-4-3.3-5.6-2z"></path></svg></a><a href="https://stackoverflow.com/users/697660/thedev6" aria-label="Link to Stack Overflow Account" target="_blank" class="px-2 py-2 hover:text-gray-400"><svg aria-hidden="true" focusable="false" data-prefix="fab" data-icon="stack-overflow" class="svg-inline--fa fa-stack-overflow fa-w-12 fa-2x " role="img" xmlns="http://www.w3.org/2000/svg" viewBox="0 0 384 512">

1<path fill="currentColor" d="M290.7 311L95 269.7 86.8 309l195.7 41zm51-87L188.2 95.7l-25.5 30.8 153.5 128.3zm-31.2 39.7L129.2 179l-16.7 36.5L293.7 300zM262 32l-32 24 119.3 160.3 32-24zm20.5 328h-200v39.7h200zm39.7 80H42.7V320h-40v160h359.5V320h-40z"></path></svg></a><a target="_blank" class="px-2 py-2 hover:text-gray-400" href="https://www.nuget.org/packages?q=thedev6">Nuget</a></div></div><div class="flex flex-col"></div><div class="flex flex-wrap px-2 mt-2 items-center bg-gradient-to-b from-gray-600 via-gray-700 to-gray-600 text-gray-200 justify-between rounded-md"><span>© Chadwick <!-- -->2021</span></div></div></div>

1<script id="__NEXT_DATA__" type="application/json">{"props":{"pageProps":{"blogs":[{"BlogGuid":"8CDEBC24-C44E-E211-9A8C-0022198EF787","Title":"Code Generator","TitleSlug":"Code-Generator","Description":"Code Generation using Enterprise Data Access Application Block","Keywords":"Code Generation, ORM, Object Relational Mapper, C# Code Generator, SignalR,C#, SQL","PublishDate":"2012-07-14","ImageUrl":"https://dev6.blob.core.windows.net/blog-images/tag-enterprise-code-gen.jpg","CommentCount":0},{"BlogGuid":"0858D557-C44E-E211-9A8C-0022198EF787","Title":"Stackoverflow","TitleSlug":"Stackoverflow","Description":"Link to Stackoverflow account","Keywords":"Stackoverflow","PublishDate":"2012-07-14","ImageUrl":"https://dev6.blob.core.windows.net/blog-images/tag-stack-overflow.jpg","CommentCount":0},{"BlogGuid":"7C7D7F92-C44E-E211-9A8C-0022198EF787","Title":"Sort Javascript arrays by multiple properties","TitleSlug":"Sort-Javascript-arrays-by-multiple-properties","Description":"Sorting arrays in Javascript Typscript","Keywords":"javascript, typescript, sort, sorting, JSLINQ, javascript linq, JLinq","PublishDate":"2012-07-14","ImageUrl":"https://dev6.blob.core.windows.net/blog-images/tag-sort-multiple-javascript.jpg","CommentCount":0},{"BlogGuid":"38B27A17-C34E-E211-9A8C-0022198EF787","Title":"Anti Patterns 2012","TitleSlug":"Anti-Patterns-2012","Description":"Rant About Anti Patterns","Keywords":"Anti Patterns","PublishDate":"2012-11-23","ImageUrl":"https://dev6.blob.core.windows.net/blog-images/tag-anti-patterns.jpg","CommentCount":0},{"BlogGuid":"FA651BA5-7C4E-E211-9003-1C6F65D566BC","Title":"Announcing my new website and blog! 1.0","TitleSlug":"Announcing-my-new-website-and-blog!-1.0","Description":"First blog post on my custom blog","Keywords":"Trivial","PublishDate":"2012-12-25","ImageUrl":"https://dev6.blob.core.windows.net/blog-images/tag-announcing-new-blog.jpg","CommentCount":0},{"BlogGuid":"2918F5EC-5C52-E211-A042-0022198EF787","Title":"MVC RSS Feed","TitleSlug":"MVC-RSS-Feed","Description":"Quick and easy Rss Feed in MVC","Keywords":"RSS, RSS Feed, MVC, C#","PublishDate":"2012-12-30","ImageUrl":"https://dev6.blob.core.windows.net/blog-images/tag-rss-feed.jpg","CommentCount":2},{"BlogGuid":"A8DAFD38-6052-E211-A042-0022198EF787","Title":"Your C# objects into Javascript","TitleSlug":"Your-C-Sharp-objects-into-Javascript","Description":"Encode and Parse information from your model into javascript in a Razor view","Keywords":"Json, Json Parse, Json Encode, javascript, C#","PublishDate":"2012-12-30","ImageUrl":"https://dev6.blob.core.windows.net/blog-images/tag-csharp-into-javascript.jpg","CommentCount":0},{"BlogGuid":"8DD52F16-2D56-E211-A042-0022198EF787","Title":"Triple DES Encryption","TitleSlug":"Triple-DES-Encryption","Description":"Easy Encryption using TripleDES","Keywords":"Triple DES, Encryption, C#","PublishDate":"2013-01-03","ImageUrl":"https://dev6.blob.core.windows.net/blog-images/tag-triple-des.jpg","CommentCount":1},{"BlogGuid":"85E4892B-B65B-E211-A042-0022198EF787","Title":"Knockoutjs - A small first step","TitleSlug":"Knockoutjs---A-small-first-step","Description":"A small first step into knockoutjs","Keywords":"Knockout.js, knock out, knockoutjs, MVC4, Razor, javascript","PublishDate":"2013-01-10","ImageUrl":"https://dev6.blob.core.windows.net/blog-images/tag-kockout-first-step.jpg","CommentCount":0},{"BlogGuid":"80CE4044-B26A-E211-ACFD-0022198EF787","Title":"MVC Drop Down Control and Model Binding to Lists","TitleSlug":"MVC-Drop-Down-Control-and-Model-Binding-to-Lists","Description":"An Html Helper to create a Drop Down List in MVC that binds back to the model","Keywords":"MVC, C#, Html Helper, Razor, Html","PublishDate":"2013-01-30","ImageUrl":"https://dev6.blob.core.windows.net/blog-images/tag-mvc-drop-down-list.jpg","CommentCount":0},{"BlogGuid":"37A89E49-88D1-E211-A1AC-0022198EF787","Title":"Knockout Generic Binding","TitleSlug":"Knockout-Generic-Binding","Description":"Clean up large bindings by defining them elswehere and applying them with a custom binding.","Keywords":"knockout, javascript, knockout.js, ko.applyBindingsToNode","PublishDate":"2013-06-09","ImageUrl":"https://dev6.blob.core.windows.net/blog-images/tag-generic-custom-ko-binding.jpg","CommentCount":2},{"BlogGuid":"253F3916-C823-E311-84F2-0022198EF787","Title":"Javascript pub sub pattern","TitleSlug":"Javascript-pub-sub-pattern","Description":"javascript pub/sub pattern using typescript with generics","Keywords":"pub sub, javascript, pub/sub, typescript, typescript generics","PublishDate":"2013-09-22","ImageUrl":"https://dev6.blob.core.windows.net/blog-images/tag-pub-sub.jpg","CommentCount":3},{"BlogGuid":"B9CB6450-7D68-E311-93F2-00155D50AFC1","Title":"The Graphinator","TitleSlug":"The-Graphinator","Description":"Adding css graph to html table","Keywords":"javascript, javascript table scrape, html table into chart, typescript","PublishDate":"2013-12-19","ImageUrl":"https://dev6.blob.core.windows.net/blog-images/tag-graphinator.jpg","CommentCount":0},{"BlogGuid":"BEBECE64-38A7-E311-93F7-00155D50C68F","Title":"Sql For Xml on related tables","TitleSlug":"Sql-For-Xml-on-related-tables","Description":"Get related sql records as a single str

1ing property","Keywords":"Sql, Xml, C#, Linq, ORM, Entity Framework","PublishDate":"2014-03-07","ImageUrl":"https://dev6.blob.core.windows.net/blog-images/tag-sql-for-xml.jpg","CommentCount":0},{"BlogGuid":"825BC5E5-49A7-E311-93F7-00155D50C68F","Title":"Html5 Video Navigation and Tracking using Knockout","TitleSlug":"Html5-Video-Navigation-and-Tracking-using-Knockout","Description":"Html5 Video Dom events, Play, Pause, Current Time","Keywords":"html5, knockout,knockoutjs,video","PublishDate":"2014-03-08","ImageUrl":"https://dev6.blob.core.windows.net/blog-images/tag-html-video-nav-track.jpg","CommentCount":0},{"BlogGuid":"FE5AC093-5AA7-E311-93F7-00155D50C68F","Title":"Map multiple SQL result sets with Entity Framework","TitleSlug":"Map-multiple-SQL-result-sets-with-Entity-Framework","Description":"Map multiple result sets with Entity Framework","Keywords":"ORM, Entity Framework, SQL,DataReader,C#","PublishDate":"2014-03-09","ImageUrl":"https://dev6.blob.core.windows.net/blog-images/tag-EF-multiple-result-sets.jpg","CommentCount":0},{"BlogGuid":"00A683C7-C4C6-E311-93F6-00155D50C494","Title":"AngleBrackets 2014 Orlando","TitleSlug":"AngleBrackets-2014-Orlando","Description":"What I learned at AngleBrackets 2014","Keywords":"AngleBrackets Conference, Typescript, Gulp,  Angular, Knockout, Durandal, Glimpse, Scott Hanselman, Ward Bell, John Papa","PublishDate":"2014-04-17","ImageUrl":"https://dev6.blob.core.windows.net/blog-images/tag-anglebrackets-2014.jpg","CommentCount":0},{"BlogGuid":"89315F89-16D4-E311-93F6-00155D50BB52","Title":"Target Multiple Frameworks with MSBuild in csproj","TitleSlug":"Target-Multiple-Frameworks-with-MSBuild-in-csproj","Description":"Target multiple .net frameworks with MSBuild in csproj","Keywords":"MSBuild, csproj, target multiple .net framework, visual studio, C#","PublishDate":"2014-05-04","ImageUrl":"https://dev6.blob.core.windows.net/blog-images/tag-multi-frameworks.jpg","CommentCount":3},{"BlogGuid":"DBDBA4F5-4403-E411-93F9-00155D50AFBF","Title":"Xml as a Data Source","TitleSlug":"Xml-as-a-Data-Source","Description":"Use Xml as a Data Source","Keywords":"C#, xml, xml serialization, Razor","PublishDate":"2014-07-03","ImageUrl":"https://dev6.blob.core.windows.net/blog-images/tag-xml-data-source.jpg","CommentCount":0},{"BlogGuid":"7E91B10C-2D0A-E411-93FB-00155D50C0CE","Title":"Looking at JavaScript through Webform C# Eyes","TitleSlug":"Looking-at-JavaScript-through-Webform-C-Sharp-Eyes","Description":"An example of a JavaScript event pattern that resembles Microsoft Webforms","Keywords":"C#, Webforms, JavaScript, JavaScript Sucks","PublishDate":"2014-07-12","ImageUrl":"https://dev6.blob.core.windows.net/blog-images/tag-javascript-through-webform-eyes.jpg","CommentCount":1},{"BlogGuid":"B4C46A3E-3012-E411-93F7-00155D50A255","Title":"Entity Framework and User Defined Parameters","TitleSlug":"Entity-Framework-and-User-Defined-Parameters","Description":"User Valued Parameters with Entity Framework","Keywords":"SQL, C#, User Defined Parameters, Entity Framework","PublishDate":"2014-07-22","ImageUrl":"https://dev6.blob.core.windows.net/blog-images/tag-sql-user-valued-parameters.jpg","CommentCount":0},{"BlogGuid":"D6C1866F-9840-E511-93FE-00155D50EA8F","Title":"Fun with NSubstitute and Fluent Assertions","TitleSlug":"Fun-with-NSubstitute-and-Fluent-Assertions","Description":"A tiny example of NSubsitute and Fluent Assertions","Keywords":"C#, NSubstitute, Fluent Assertions, Unit Test, Testing","PublishDate":"2015-08-10","ImageUrl":"https://dev6.blob.core.windows.net/blog-images/tag-tests.jpg","CommentCount":0},{"BlogGuid":"52F74410-AC40-E511-93FE-00155D50EA8F","Title":"Interview Test 2015","TitleSlug":"Interview-Test-2015","Description":"A Race Track C# test for object oriented principles.","Keywords":"Interview Test, Object Oriented Programming, C#","PublishDate":"2015-08-11","ImageUrl":"https://dev6.blob.core.windows.net/blog-images/tag-race-cars.bmp","CommentCount":0},{"BlogGuid":"C3F151A1-0442-E511-93FE-00155D50EA8F","Title":"SqlMeta Code Generation Tool","TitleSlug":"SqlMeta-Code-Generation-Tool","Description":"A C# Strongly Typed Representation of Sql Schema","Keywords":"SQL, C#, Code Generator, Sql Meta Information, T4 Templates","PublishDate":"2015-08-13","ImageUrl":"https://dev6.blob.core.windows.net/blog-images/tag-sql-meta.jpg","CommentCount":0},{"BlogGuid":"474622B3-5E46-E511-93FE-00155D50EA8F","Title":"Software Development Life Cycle","TitleSlug":"Software-Development-Life-Cycle","Description":"Ramblings on Software Development Life Cycle","Keywords":"Software Development Life Cycle,SDLC,Scrum,Kanban","PublishDate":"2015-08-19","ImageUrl":"https://dev6.blob.core.windows.net/blog-images/tag-agile.jpg","CommentCount":0},{"BlogGuid":"99990A9F-E654-E511-93FE-00155D50E135","Title":"A Testable WCF Wrapper","TitleSlug":"A-Testable-WCF-Wrapper","Description":"A Wcf Wrapper that will properly disposes of wcf resources","Keywords":"WCF, C#, WCF Wrapper","PublishDate":"2015-09-06","ImageUrl":"https://dev6.blob.core.windows.net/blog-images/tag-wcf-wrapper.jpg","CommentCount":3},{"BlogGuid":"A1CC128E-93B2-E511-9404-00155D50C494","Title":"Entity Framework DbContext Wrapper","TitleSlug":"Entity-Framework-DbContext-Wrapper","Description":"A class to wrap the usage and lifecycle of Entity Framework DbContext","Keywords":"DbContext, EntityFramework, DbWrapper, DbContext Wrapper, Repository over Entity Framework, C#","PublishDate":"2016-01-03","ImageUrl":"https://dev6.blob.core.windows.net/blog-images/db-wrapper.jpg","CommentCount":2},{"BlogGuid":"95F387DD-1930-E611-9402-00155D50C68F","Title":"Treadmill Retry","TitleSlug":"Treadmill-Retry","Description":"A dead simple retry library with callbacks for your own retry behavior.","Keywords":"C#, retry, .net retry library","PublishDate":"2016-06-11","ImageUrl":"https://dev6.blob.core.windows.net/blog-images/tag-retry.jpg","CommentCount":2},{"BlogGuid":"C301C10D-78CD-E711-9404-00155D44C455","Title":"Moq vs NSubstitute","TitleSlug":"Moq-vs-NSubstitute","Description":"Moq vs NSubstitute favoring NSubstitute","Keywords":"Moq, NSubstitute, Testing, Test","PublishDate":"2017-11-19","ImageUrl":"https://dev6.blob.core.windows.net/blog-images/tag-moq-vs-nsub.png","CommentCount":0},{"BlogGuid":"F8BE5B1C-F1EC-E711-BD61-00155D44B683","Title":"Scrum is what you do when you dont know what is being done","TitleSlug":"Scrum-is-what-you-do-when-you-dont-know-what-is-being-done","Description":"Scrum can assist you in creating software or it can stand in your way. Please choose wisely.","Keywords":"Scrum,Sdlc,Agile,Software Development Life Cycle","PublishDate":"2017-12-29","ImageUrl":"https://dev6.blob.core.windows.net/blog-images/tag-scrum.png","CommentCount":0},{"BlogGuid":"2401e731-e8d6-4eca-8d5a-7841ebf87d10","Title":"Logic Ladder","TitleSlug":"Logic-Ladder","Description":"A C# library to assist in implementing logic and behavior as a series of steps.","Keywords":"Logic Ladder, C#, nuget, Ap

1plication Logic","PublishDate":"2021-05-12","ImageUrl":"https://dev6.blob.core.windows.net/blog-images/logic-ladder.png","CommentCount":0}]},"__N_SSG":true},"page":"/DeveloperBlog","query":{},"buildId":"UEAILG7XepFnegu06qP4J","isFallback":false,"gsp":true}</script>

1<script nomodule="" src="/_next/static/chunks/polyfills-8683bd742a84c1edd48c.js"></script>

1<script src="/_next/static/chunks/webpack-1fcfb52dd685e6ffbb87.js" async=""></script>

1<script src="/_next/static/chunks/framework-12b998e3f139f1eb798c.js" async=""></script>

1<script src="/_next/static/chunks/commons-ce1eb193d2064abecece.js" async=""></script>

1<script src="/_next/static/chunks/main-910ac74a12454b8967cd.js" async=""></script>

1<script src="/_next/static/chunks/pages/_app-2755b7cda550b9b0ca76.js" async=""></script>

1<script src="/_next/static/chunks/a9a7754c-2e9969d04ec4ace6c1fe.js" async=""></script>

1<script src="/_next/static/chunks/75fc9c18-9942a58048f91d946457.js" async=""></script>

1<script src="/_next/static/chunks/485-bd9cde59bf2f2502a3e6.js" async=""></script>

1<script src="/_next/static/chunks/762-a6508b74925918f1abd8.js" async=""></script>

1<script src="/_next/static/chunks/pages/DeveloperBlog-fe3e88c4623d3f70e103.js" async=""></script>

1<script src="/_next/static/UEAILG7XepFnegu06qP4J/_buildManifest.js" async=""></script>

1<script src="/_next/static/UEAILG7XepFnegu06qP4J/_ssgManifest.js" async=""></script>

1</body></html>