Simple Ways to Inspect the SQL Executed by Entity Framework Core
Slow SQL or incorrect or missing indexes can cause performance issues in an API. And those issues can be difficult to fix or even find. I use a variety of tools when investigating slow APIs, but if the API uses a SQL database I have a few that are invaluable in finding ways to improve […]
AspNetCore – multi tenant tips and tricks
In two recent posts, I blogged about SignalR in .AspNet Core 2.1, and automating boilerplate multitenancy code in Entity Framework Core 2.1. Both these blogs alluded to knowing the identity of the calling user through claims and dependency injection. This blogs ties together those loose ends to show how that can be done. Authenticating the […]
Entity Framework Core 2.1 – Automate all that boring boiler plate!
In any real world enterprise application, you end up writing a lot of similar, tedious boilerplate code for bookkeeping . This logic results in a data model where each table is adorned with a lot of non-domain specific columns – does this look familiar? There are three common patterns at work here: Auditing – […]