Josep Ferrer·Nov 17, 2022Member-only4 killer SQL commands to take your SQL skills to the next levelAnd 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 —…Programming7 min readProgramming7 min read
Juldhais Hengkyawan·Nov 7, 2022Some C# Features that You Probably Don't Know YetGlobal 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…Csharp3 min readCsharp3 min read
Maximiliano ContieriinLevel Up Coding·Dec 16, 2022Code Smell 186 — Hardcoded Business ConditionsYou 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…Ftx2 min readFtx2 min read
Mohamed MayalloinBetter Programming·Sep 30, 2022Open-Closed Principle: The Hard PartsThe 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 PrincipleProgramming13 min readProgramming13 min read
Alper EbiçoğluinVolosoft·Nov 25, 2022Inheritance Strategies in Entity Framework Core 7In 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…Entity Framework Core4 min readEntity Framework Core4 min read
Pushpak Sharma·Nov 19, 2022SQL Query Performance OptimizationObjective 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…Database8 min readDatabase8 min read
Zack Yang·Dec 1, 2022400% faster, Rapid data insertion in Entity Framework Core 7Because 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…C Sharp Programming2 min readC Sharp Programming2 min read
Maximiliano ContieriinLevel Up Coding·Dec 6, 2022Code Smell 184 — Exception Arrow CodeArrow 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) {…Code2 min readCode2 min read