Mar 29
Views: 261
Another way to read data from the configuration data Options pattern introduction Options pattern is a flexible configuration data management way that enables us to use strongly typed configurations. It uses classes to bind groups of related configurations. We can inject these classes via dependency injection with IOptions<T> to include...
more...
Mar 28
Views: 745
In today’s story we are going to talk about what Tasks are and have a brief introduction on the Task Parallel Library (TPL). We will also give a small preview of the Async & Task-Based Asynchronous Patterns. Tasks To begin talking about what tasks actually are, let’s take a step...
more...
Mar 28
Views: 2057
gRPC is a powerful framework for working with Remote Procedure Calls. RPCs allow you to write code as though it will be run on a local computer, even though it may be executed on another computer. One of the key advantages of gRPC is its use of HTTP/2, which...
more...
Mar 25
Views: 697
Creating background services in .NET Core is a powerful way to perform long-running, background tasks that are independent of user interaction. These tasks can range from data processing, sending batch emails, to file I/O operations — all critical for today’s complex application ecosystems. This guide delves deep into the architecture,...
more...
Mar 25
Views: 2614
Pagination allows you to retrieve a large number of records split into pages, instead of returning all the results at once. This is especially useful in scenarios where you need to retrieve a large number of records. In this article, I present how to implement OffSet and Keyset pagination...
more...
Mar 24
Views: 882
Introduction A common table expression (CTE) is a temporary named result set that you can reference within a SELECT, INSERT, UPDATE, or DELETE statement in SQL Server. CTEs were introduced in SQL Server 2005 and are similar to derived tables and views. CTEs are defined by specifying a CTE name...
more...
Mar 23
Views: 402
The Deadlock Dilemma 🔒 In the world of multithreaded programming, deadlocks lurk like silent assassins, waiting to strike when you least expect it. A deadlock occurs when two or more threads become entangled in a vicious cycle, each holding a resource that the other needs, resulting in a perpetual stalemate....
more...
Mar 22
Views: 672
Introduction Delegates are a fundamental concept in C# that allow you to treat methods as objects. They provide a way to define a type that represents a reference to a method, enabling you to encapsulate and pass around methods as parameters, store them in variables, and invoke them whenever needed....
more...
Mar 22
Views: 519
For individuals who work closely with application development, terms like React and ASP.NET Core are not foreign. The most popular uses of these two technologies are in application and software development. Like any other technology, these aren’t flawless, though. The combination of these two allows for the full enjoyment of...
more...
Mar 22
Views: 704
LINQ (Language Integrated Query) has revolutionized the way we interact with data in C#. It offers a consistent, readable, and concise way to manipulate collections, databases, XML, and more. However, the beauty and ease of LINQ can sometimes mask performance pitfalls. Understanding LINQ’s underpinnings Before we jump into optimizations, it’s...
more...
Mar 21
Views: 912
Introduction A common table expression (CTE) is a temporary named result set that you can reference within a SELECT, INSERT, UPDATE, or DELETE statement in SQL Server. CTEs were introduced in SQL Server 2005 and are similar to derived tables and views. CTEs are defined by specifying a CTE name...
more...
Mar 20
Views: 524
THE GREAT DAY HAS COME! I promise not to disappoint you, this is the last article in the series: SQL Tuning In all the articles I said that the recommendation was to read the execution plan, and guess what we are going to do in this one? Let’s eat the...
more...
Mar 20
Views: 332
No one likes to deal with a slow query. However, before you handle with a query, I suggest you understand which architecture it runs on, you can be sure it will clear up many doubts. This is the second article in a series of articles on SQL Tuning, the idea...
more...
Mar 20
Views: 616
Nobody likes dealing with a slow query. Besides being stressfull to wait for, it can be a huge impact in your database. Some simpler approaches can help resolve this. I want to start a series of three articles explaining about Tuning and architecture. To begin, I want to start with...
more...
Views: 656
Nobody likes dealing with a slow query. Besides being stressfull to wait for, it can be a huge impact in your database. Some simpler approaches can help resolve this. I want to start a series of three articles explaining about Tuning and architecture.
Mar 18
Views: 720
Imagine crafting a library app where users effortlessly find books by title, author, or genre. Traditional search methods drown you in code. But fear not! Dynamic Querying in C# saves the day. In our tale, crafting separate search methods for each book attribute becomes a headache. The code becomes a...
more...
Mar 18
Views: 739
File reading operations in C# are crucial for many applications, often requiring efficiency and optimal performance. When handling file reading tasks, employing the right strategies can significantly impact the speed and resource utilization of your application. Here are some best practices to ensure efficient file reading in C#: 1. Choose...
more...
Mar 16
Views: 292
What is API testing? First, we need to know about API. API stands for Application Programming Interface. That’s all. Then, you may ask: what is its real meaning? So, let’s go with Application Programming first. Application programming usually has 3 layers: User Interface, Business Logic, and Data Storage. Did you...
more...
Mar 16
Views: 761
Performance is paramount when developing web applications. A slow, unresponsive application results in poor user experience, losing users, and possibly business. For ASP.NET Core developers, there are many techniques and best practices to optimize application performance. Let’s explore some of these approaches in this article. Understanding performance bottlenecks When we...
more...
Mar 15
Views: 376
Mastering SQL with practical examples SQL is a powerful tool for managing and manipulating data in relational databases. While basic SQL queries are essential, mastering advanced SQL queries empowers data professionals to extract complex insights and perform sophisticated data transformations. In this article, we’ll explore 20 advanced SQL queries that...
more...