Treating (complex) SQL views as entities in .NET with SQL triggers.

Did you know that you can use a SQL view for your entities in your favorite ORM framework? In this article I will discuss the reasons why one would do that (and why not). I will provide a case study where we try to achieve this, and try to find workarounds for problems that come along the way.

Let's create a stock tracking app in .NET MAUI - part 4

The stock tracking app is almost done. This part is about finetuning and optimizations. In this part we will implement a loading indicator and display the total portfolio value and total target % on the main page. To finish things off will revisit the StockPositions property and use a better alternative for the ObservableCollection.

Advent of code 2023 - day 5 (excel + C#)

The elves are asking for help to organize and understand their food production problem. I started this exercise with excel and switched to C# to solve the second part of the problem.

Let's create a stock tracking app in .NET MAUI - part 3

The stock tracking app is beginning to take shape. However, it is still missing one of the essential features: charts. In this part we will implement a details page where we can see the history of a stock's price on a candlestick chart. We should also be able to edit the amount of shares owned and target %, and a delete button will be added. Finally, we will color positive and negative price changes and highlight stocks based on current value vs. target value.

Let's create a stock tracking app in .NET MAUI - part 2

We continue the journey of developing a stock tracking app. In the last part we created the layout, integrated with a third-party API to load stock data, and implemented some caching mechanisms to reduce the request rate. In this part we implement the value change for the different periodicities and a sorting functionality for all columns. We will also implement an add button, so that we no longer have to fiddle around in json.

Let's create a stock tracking app in .NET MAUI

I have a keen interest in personal finance and investing. An excel file or third party apps don't really provide the tools that I'm looking for to track my investments. So as a developer, what better way to explore a new technology (.NET MAUI) than to create such a app yourself? This article will provide a step-by-step guide to do this. I will assume that the reader understands the fundamentals of C#, XAML and MVVM.