Suppose we’ve got two lists that we would like to join based on, say, common Id property. With LINQ the code would look something along these lines: resulting list of …
Tag Archives: howto
ASP.Net Core – Resolving types from dynamic assemblies
It is not a secret that ASP.NET core comes with dependency injection support out of the box. And we don’t remember ever feeling it lacks features. All we have to …
Continue reading “ASP.Net Core – Resolving types from dynamic assemblies”
Attaching debugger to dynamically loaded assembly with Reflection.Emit
Imagine a situation where you’d like to attach a debugger to an assembly that you have loaded dynamically? To make it a bit more plausible let us consider a scenario. …
Continue reading “Attaching debugger to dynamically loaded assembly with Reflection.Emit”
ARR: Setting up
Not so long ago a client asked us to spec up their CI/CD pipeline. They are going through devops transformation and as part of their “speed up delivery” objective they …
Entity Framework Core 3.1 – dynamic WHERE clause
Every now and then we get tasked with building a backend for filtering arbitrary queries. Usually clients would like to have a method of sending over an array of fields, …
Continue reading “Entity Framework Core 3.1 – dynamic WHERE clause”
Entity Framework Core 3.1 – Peeking Into Generated SQL
Writing LINQ that produces optimal SQL can be even harder as developers often don’t have visibility into the process. It becomes even more confusing when the application is designed to …
Continue reading “Entity Framework Core 3.1 – Peeking Into Generated SQL”
Monitoring Mikrotik with InfluxDb
With unlimited fibre plans it is less important to keep track on who is the biggest content consumer in the office, but it still is interesting to find out. Mikrotik …
Entity Framework Core 3 – Custom Functions (Using IMethodCallTranslator)
Every now and then Stack Overflow provides fantastic opportunities to learn something new. One user asked whether SQL Server’s DECRYPTBYPASSPHRASE can be implemented with Entity Framework Core 2.2 so they …
Continue reading “Entity Framework Core 3 – Custom Functions (Using IMethodCallTranslator)”
Monitoring SQL Server: fiddling with sp_whoisactive output
Building up on from basic telegraf inputs we now want some actual SQL data. And this time around it’s going to be not just numeric telemetry, we’d gain some insights …
Continue reading “Monitoring SQL Server: fiddling with sp_whoisactive output”
Monitoring SQL Server: setting up Logstash with telegraf
Having set up basic ELK stack we probably should get on to ingesting some data. Wait, what about schema? Theoretically, we could play it very strict and define our expected …
Continue reading “Monitoring SQL Server: setting up Logstash with telegraf”