Category: DevTips

Sharing my best software development tips and tricks. From quick tips to actual guides and solutions. 

Microsoft Graph g-raph (giraffe) - the spirit animal of Microsoft Graph

One way to fix “Unsupported or invalid query filter clause specified for property” for your Microsoft Graph API queries

This article explains one possible fix to an annoyingly generic exception thrown by the Microsoft Graph API (namely, “Unsupported or invalid query filter clause specified for property”) or an even more generic exception thrown by PnP PowerShell (“Exception of type ‘PnP.PowerShell.Commands.Model.Graph.GraphException’ was thrown.”) when you’re trying to query Graph API…Continue reading One way to fix “Unsupported or invalid query filter clause specified for property” for your Microsoft Graph API queries

PostgreSQL everywhere

How to store a complex object as JSON in a PostgreSQL database using Entity Framework (Npgsql)?

Okay, that’s a title and a half. But let’s see – what are we actually doing and why? In my particular case, I had to store a Dictionary<string, string> in a Postgres database. By default, that’s not something Entity Framework handles. But as usual, there’s a way around that –…Continue reading How to store a complex object as JSON in a PostgreSQL database using Entity Framework (Npgsql)?

Entity Framework - am I right?

How to fix another weird Entity Framework Core dependency issue?

Okay – so that’s a non-descriptive title if I’ve ever written one – I apologize for that! I just couldn’t figure out a way to shorten the error when “Microsoft.AspNetCore.Diagnostics.EntityFrameworkCore” is referencing “Microsoft.AspNetCore.Http.Abstractions”, and even though you’re not referencing that dependency directly, you get an error where you have both…Continue reading How to fix another weird Entity Framework Core dependency issue?

I'm not saying it was built with Azure Functions, but it was definitely built with Azure Functions.

How to fix “The listener for function was unable to start. Out of retries creating lease for partition 0”

Here is another pretty quick one – trying to debug Azure Functions fails with a confusing error message about failing to create a lease for a partition. But as usual, the fix is (probably) simple, and this article explains what to do :) So, hey future me, finding this article…Continue reading How to fix “The listener for function was unable to start. Out of retries creating lease for partition 0”