MVVM’s command binding has probably been the same for more than a decade. Hence you should take what you read with a grain of salt. The Problem Patterns – WPF Apps With The Model-View-ViewModel Design Pattern | Microsoft Docs has a detailed account of the pattern. It also explains the code it suggests to a […]
Add config sections and values in Azure Function Configuration
Most developers are familiar with defining configuration sections in appsettings.json or a json file, and then read it through IConfiguration. However, Azure Functions uses environment variables. Though there are ways you can use a json file in azure functions, it will hamper the flexibility of configuring azure functions. Environment variables are stored as a key-value […]
Deploy & Access Certificates to Service Fabric Node from Azure Key Vault
If you are writing a secure code, there will be more than one instance where you need certificates to achieve encryption and decryption. Always depend on Azure Key Vault to read certificates and keys. However, there are many instances where you need the certificates to be installed in the node itself. This article is to […]
Benchmarking Index Fragmentation With Popular Sequential GUID Algorithms
In a multi-tenant data insert scenario, GUID is a great data type for primary key. Since it is unique globally, you will not need to rely on any range or custom logic. However, if you extend these columns as index, you will end up with frequent index fragmentation and hence bad performance. In this post, […]
Writing an asynchronous RelayCommand implementing ICommand
If you are familiar with MVVM, then you are already familiar with relay commands. We use relay commands to map a method with the ICommand raised from a control. Below is the typical code snippet you may have seen a lot of time. The class below is pretty simple; it accepts a method and allows […]
Refer azure runbook activity output in PowerShell expression
When you are creating a runbook with multiple activities, often you will encounter the need of referring an activity output in another activity. Thankfully, all the activities in the runbook can refer another activity in the parameter pane. However, when you have a piece of powershell script which needs to use the same, you don’t […]
Working around the bug “Instead Of Trigger on View returns no output”
There is an inherent and documented bug with SQL for a very long time where the database will not yield any output when you have got an “Instead Of” trigger on a view and you update the view. The bug is currently updated as “Won’t fix” as the fix will alter the core bits of […]
Get text from RichTextBlockOverflow Control
RichTextBlockOverflow is one of my favorite control. As we all know, it allows you to render the overflown text from a RichTextBlock. Virtually you can render the overflow text to any number of level. Below is how a the overflow happens when you got one RichTextBlock and two RichTextBlockOverflow to render the overflown text. However, […]
A poor man’s implementation of row level security in SQL
Often I have come across situations where the enterprise customers want to restrict data availability to their employees / IT not only from the application but also at the database level. Government / Public sectors have a common requirement that they don’t want everybody at their IT team to be able to query everybody’s data. […]
Complete XAML Solution For SelectAll In Datagrid
Over the period of time lot of asks and solutions were made for selectall selector for DataGrid. However, I failed to see a solution which is completely built on XAML. When my friend approached me, I thought that I will write my own. The idea is to have a template column with a separate definition for […]