And how to master these time-saving commands — SQL is a normally self-learned language. Its simplicity and fast learning curve make it the perfect language to crash into Data Science. I am pretty sure you have self-learned SQL, and you are already really good at it. However, with the rising volume of data, the need for skilled —…

Global Using Directives Before we had this feature, we had to always import the same namespace over and over in each class file. // Before using System; using System.Linq; using System.Collection.Generic; Since C# 10, a new global keyword allows us to declare frequently used namespaces in applications. We only have to create one…

You are FTX and your code allows special cases — TL;DR: Don’t add hard business rules to your code. Problems Open / Closed Principle Violation Hardcoding Testability Solutions Reify the condition. Create configuration options and set the exception on the configuration behavior. Don’t use Settings/Configs. Context According to Reuters, in a recent FTX scandal, there was a hardcoded condition to skip risk controls…

The Open-Closed Principle is the second principle of SOLID. Let’s know what OCP is, its limitations, and how can we follow it correctly — Introduction SOLID principles are a set of principles set by Robert C.Martin (Uncle Bob). The main goal of these principles is to design software that is easy to maintain, test, understand, and extend. These principles are: Single Responsibility Principle Open-Closed Principle

In this article, I’ll show you all the object mapping strategies of EF Core and especially the new one: TPC Inheritance Mapping. TPC mapping is the new feature introduced with Entity Framework Core 7. It’s called Table Per Concrete type inheritance mapping. I’ll explain the EF Core’s inheritance mapping strategies…

Objective Bitmap and hash indexes Using different types of indexes to improve performance Challenges with joining tables When to use partitioning to improve performance Collecting statistics about data in tables What is scanning? Scanning is a linear operation, moving from one row to the next, and performing some operation, like applying a filter to…

Because in the previous version, Entity Framework Core (EF Core) could not efficiently insert, modify and delete data in batches, so I developed Zack.EFCore.Batch, an open-source project, which was quite popular and obtained more than 400 stars. Since .NET 7, EF Core has built-in support for the efficient batch updating…

Arrow code is a code smell. Exception polluting is another. This is a mortal combination. — TL;DR: Don’t cascade your exceptions Problems Readability Complexity Solutions Rewrite the nested clauses Context In the same way arrow code is hard to read, handling exceptions is a usual case when we must address the topics in a cascade way. Sample Code Wrong class QuotesSaver { public void Save(string filename) {…