Skip to content

Timur and associates

Notes of an IT contractor

Tag Archives: howto

LINQ: Dynamic Join

Photo by Ilya Pavlov on Unsplash

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 […]

Posted bytimur21/12/202021/12/2020Posted inDev TipsTags: c#, 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 […]

Posted bytimur03/12/202010/12/2020Posted inDev TipsTags: aspnetcore, c#, howtoLeave a comment on ASP.Net Core – Resolving types from dynamic assemblies

Attaching debugger to dynamically loaded assembly with Reflection.Emit

Database

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. […]

Posted bytimur03/11/202028/11/2020Posted inDev TipsTags: c#, howtoLeave a comment on Attaching debugger to dynamically loaded assembly with Reflection.Emit

ARR: Setting up

Database

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 […]

Posted bytimur13/10/202020/11/2020Posted inDev TipsTags: howtoLeave a comment on ARR: Setting up

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, […]

Posted bytimur14/08/202018/09/2020Posted inDev TipsTags: ef-core, howtoLeave a comment on 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 […]

Posted bytimur06/07/202013/08/2020Posted inDev TipsTags: c#, ef-core, howto1 Comment on 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 […]

Posted bytimur18/04/202005/05/2020Posted inItTags: howto, mikrotik

Entity Framework Core 3 – Custom Functions (Using IMethodCallTranslator)

Database

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 […]

Posted bytimur26/01/202023/02/2020Posted inDev TipsTags: c#, ef-core, howto

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 […]

Posted bytimur04/10/201917/03/2020Posted inDev TipsTags: howto, monitoring1 Comment on 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 […]

Posted bytimur27/09/201913/03/2020Posted inDev TipsTags: howto, monitoring1 Comment on Monitoring SQL Server: setting up Logstash with telegraf

Posts navigation

1 2 Older posts
Timur and associates, Proudly powered by WordPress. Privacy Policy