“Code Tips” or “Programming” (both aliases for this term in my site’s taxonomy) is my category for whatever posts I’m able to come up with, that handle programming, code quality and/or handy workarounds. Is code directly involved? Then the post should be filed under here!
This is meant to distinguish posts from different things, like configuration or user analytics -related posts. Even tips of fixing Azure DevOps pipelines go elsewhere, because that’s not programming.
Azure Functions use dependency injection, and that allows us to define all kinds of prebuilt or custom-built services as being available for our functions really easily. This is a really easy way to initialize scoped resources to be used in your different functions… But how do you actually configure them in an Azure Functions App? Problem Okay, a step back – there’s a bit of a problem that we need…Continue reading How to configure Azure Function’s startup
This article explains how to get rid of sudden and unexplainable 401 Access Denied errors when trying to authenticate against a fairly fresh Microsoft 365 / SharePoint Online tenant. This issue seems to be caused by a long-ish project to finally retire ACS – Azure Access Control service) on SharePoint (it’s retired everywhere else already!) Note: This might still be an updating story, as the situation with ACS is definitely……Continue reading App authentication woes on SharePoint (Token request failed. The remote server returned an error: (401) Unauthorized.)
Hah – another interesting one. This article describes how to resolve an error along the lines of “Microsoft.Data.SqlClient: Microsoft.Data.SqlClient is not supported on this platform.“, thrown by the Azure Functions host. Apparently, you can run into this issue either on your local development machine or even in Azure. Problem For me, this error popped up after some house cleaning tasks – dependency updates, merging feature branches… You know the stuff.…Continue reading How to resolve “Microsoft.Data.SqlClient is not supported on this platform.” in an Azure Function App?
This article explains how to perform a very simple and lightweight database connection test for an existing database context. A while ago, I needed to develop a simple API that I can poll from a load balancer to see whether: An Azure service hosting it is up and It has a connection to its SQL database This simple API would be used for monitoring purposes – simple stuff, sure, but…Continue reading How to verify connection to database in Entity Framework Core?
This article offers yet another possible fix to an issue, where trying to call SaveChanges() in Entity Framework Core throws a pretty generic “An error occurred while updating the entries”-exception, and you’re left wondering what in tarnation is wrong this time. And admittedly, that’s a really generic error, so it could pretty much be whatever. But in this article, I’ll go through one possibility – hopefully, it helps! Problem So…Continue reading How to resolve another “An error occurred while updating the entries” exception in Entity Framework Core
Recently, while building an app service to host a .NET Core API, I had to implement the logic for using both Read-Only and Read-Write Database Contexts for Entity Framework Core. In this particular case, it was the same database – just different contexts, because depending on the location of the app service the app was deployed in, read and write operations might actually go to different database instances, That’s really…Continue reading How to implement multiple Connection Strings for one DbContext in EF Core?
Sometimes you’ll need the default identity for your ASP.NET Core application, but want to disable the registration of new users. Sounds pretty basic, right? However, there’s actually no easy switch you can just flip to enable or disable said functionality. I went through a lot of different articles and ideas by other people. Most of them involved fiddling with IdentityController, creating new scaffolded pages, adding new Actions with redirection code,…Continue reading How to disable “Register” action in ASP.NET Core?
Every now and then comes the need to write your console output to a log file. There’s a simple way to do this in .NET Framework, and quite a few online articles detailing a borderline one-liner on how to do achieve it: Adding a log file listener(s) by calling Debug.Listeners – something like this: (Source) However, this doesn’t work in .NET Core anymore. Problem: Everything changes in .NET Core Using…Continue reading Adding Debug listeners to your console application fails in .NET Core
So, another interesting issue I ran into when developing Azure Functions locally. What an endless bag of funsies! 😁 This time, the issue was simple but infuriating – my Azure Functions host would just silently close when debugging: none of the breakpoints would be hit, no information would be logged anywhere. Azure Functions Core Tools (2.4.432 Commit hash: 3371a87e0fce2aa35986c0de8e77d5d618163b91) Function Runtime Version: 2.0.12332.0 The system cannot find the file specified…Continue reading Azure Functions host quits with “The system cannot find the file specified”