Author Archives: Gaston
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
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
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
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
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
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
Database Normalization
Introduction After I published last week’s article somebody asked me why I stated that (in this case) the problem didn’t originate in having a function with logic, but merely having to work with a database that is not normalized. So let’s talk … Continue reading
Unit Testing your Repositories–the code
In the previous post I started to write about how to set up your unit tests in the repository code. The title was (maybe a bit misleading) “Unit testing your Repositories”. So I had to promise to write an article … Continue reading
Unit testing your Repositories
The problem We have created our data layer, and of course we want to test it. It is very hard to use a (physical) database to test your code. There are some problems with this (commonly used) approach: Unit tests … Continue reading
Creating an OData V4 service
I’m writing an agenda application, where the data can be delivered to the calendar control using either REST or OData V4. I choose the latter because this will allow for much more flexibility afterwards. I already have an MVC 5 … Continue reading
MSDev.pro blog 