Why Multiple JOINs are bad for Query or Do Not Get in the Way of Optimizer
Recently, I came across an application that generated DB queries. I understand that there is...
LinqToSolr – use LINQ to obtain data from Solr
Due to the fact that in my company, Solr was chosen as a full-text search platform, there appeared a strong desire to simplify the work...
Functional C#
C# is a multi-paradigm programming language. Recently, the course has been set towards new functional constructions in C#. We can go...
Specification Design Pattern in C#
In computer programming, the specification pattern is a particular software design...
SOLID: Single Responsibility Principle
In this article, I will try to describe one of the famous principles of the object oriented programming, that is a part of another famous...
Why Using Unit Tests is a Great Investment into High-Quality Architecture
I have decided to write this article in order to show that unit tests are not only a tool to grapple with regression in the code but is...
CombGuid: Generation of SQL Server-friendly Guid Values in .NET Applications
Usage of UUID as a primary key for tables has a bunch of pros, including the option to retrieve IDs...
Eliminating Duplication of Where Expressions in Application
Assume you have products and categories. A client says that it is necessary to use other business processes for the categories with the...
Better ALTER than DROP
In this article, I am going to provide a construction for deleting an object before creating it....
Hangfire: Task Scheduler for .NET
Hangfire is a multi-threaded and scalable task scheduler built on client-server architecture on...
