Category Archives: Development

Why would you use Common Table Expressions?

Introduction In this article I suppose that you have a good understanding of SQL already. I will introduce some concepts very briefly before moving on to Common Table Expressions. Below you can find the relevant database diagram of the database … Continue reading

Posted in Codeproject, Databases, Development, SQL | Tagged , | Leave a comment

Creating a Visio Add-In in VS2017

Problem statement A good friend asked me the following question: How can I in Visio change the color to a previously selected color just by selecting a shape? Sounds simple enough, but there are some caveats, so here is my … Continue reading

Posted in .Net, Codeproject, Development, Office Development | Tagged , | Leave a comment

Architecture of a Polyglot Azure Application

Introduction I started working on a C# project that will communicate requests to several different partners, and receive feedback from them. Each partner will receive requests in their own way. This means that sending requests can (currently) be done by … Continue reading

Posted in Analysis, Architecture, Azure, Cloud, Codeproject, Development | Tagged , | 1 Comment

Areas in ASP.NET Core

Introduction In a default MVC application everything is organized by Controllers and Views. The controller name determines the first part of your URL, and the controller method the second part. By default the view that will be rendered has the … Continue reading

Posted in .Net, Codeproject, Development, MVC, Web | Tagged , , , | 4 Comments

Automating the creation of NuGet packages with different .NET versions

Introduction I created a couple of straightforward libraries to be used in almost every project. So evidently these libraries are a good candidate for NuGet. This will decouple the libraries from the projects that they are used in. It also … Continue reading

Posted in .Net, Architecture, Codeproject, Development | Tagged | Leave a comment

Improving throughput by using queue-based patterns

Introduction In my current project we let the users run simulations. Because of flexibility, the calculations are performed by Excel spreadsheets. There are many different spreadsheets available, for different kinds of simulations. When the calculations rules for one of the … Continue reading

Posted in Architecture, Azure, Codeproject, Design Patterns, Development | Tagged , , , | Leave a comment

Knockout, self, this, TypeScript. Are you still following?

Introduction I’m working on an MVC application with simple CRUD operations. I want the following functionality (don’t mind the Flemish (Dutch) titles): Remember, I’m “graphically handicapped”, so I’m afraid that my users will have to do with the standard Bootstrap … Continue reading

Posted in Codeproject, Debugging, Development, JavaScript, TypeScript | Tagged , | Leave a comment