Author Archives: Gaston

Unknown's avatar

About Gaston

MCT, MCSD, MCDBA, MCSE, MS Specialist

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 , , , | 9 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

Implementing the Excel Simulator in F#

Introduction In my previous post we talked about how to structure an Excel workbook to make it easy to perform changes. As a side effect we have now a good idea of what is the data, and what is the … Continue reading →

Posted in .Net, Codeproject, Development | 2 Comments

Structuring your Excel – “the hidden agenda”

Introduction Most developers don’t like Excel as a “development platform”. Many projects are migration projects from an Excel solution to a “real application”. And often this is worth the trouble. But in some cases Excel has a lot of advantages. … Continue reading →

Posted in Architecture, Codeproject | Tagged | 7 Comments

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

Structuring an MVC app for easy testing

Introduction In this article I want to give you some handles to structure your MVC applications in such a way that they become easier to test. The article isn’t really about MVC, but if you want more information on MVC, I … Continue reading →

Posted in .Net, Codeproject, Development, MVC, Testing | Leave a comment

What is the role of the database?

Introduction Most non-trivial applications will use a database to store data. This database can be relational or not, but some data store will be needed. Most modern database management systems (DBMS) can do much more than just storing data, and … Continue reading →

Posted in Architecture, Codeproject, Databases, Development, Entity Framework | Tagged | 2 Comments