Category Archives: Codeproject

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 Codeproject | Leave a comment

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 | 2 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 | Leave a comment

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

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