In this post, we will see how to create and manage a SQLite database using C#. We will create a minimal API to use the database, implement a repository pattern to abstract database operations and finally, we will write unit tests to verify our code.The SQLite database we will use is named TestDb and it… Read More: C# – Management of a SQLite database »
In this post, we will see how to manage the PostgreSQL database created in the post “Python – Management of a PostgreSQL database”, using C#.We will define a Minimal API for managing the database using C# and Dapper, combined with the Repository Pattern. Finally, we will add the Unit Test to check that all methods… Read More: C# – Management of a PostgreSQL database »
In this post, we will see some concurrent collections that we could use in our multi-threaded application where, managing shared data between threads, can introduce complexity and potential error such as race conditions or deadlocks. .NET addresses these cases with its concurrent collections, found in the System.Collections.Concurrent namespace. These collections are designed to be thread-safe… Read More: C# – Concurrent collections »
In this post, we will see how to use Serilog in our .net applications.But first of all, what is Serilog?Serilog is a diagnostic logging library for .NET applications. It is designed to be easy to configure and extend, offering a rich set of sinks (outputs) and enrichers. One of the key features of Serilog is… Read More: C# – Serilog »
In this post, we will see the ACID properties and how we can implement it using C#.But first of all: what is ACID?ACID is an acronym that stands for Atomicity, Consistency, Isolation, and Durability. It’s a set of properties that databases strive to achieve to guarantee that database transactions are reliable, even in the face… Read More: C# – ACID properties in Database Management »
In this post, we will see what is Span<T> in C# and how we can use it to improve performance.But first of all, what is a Span<T>?From Microsoft web site:“System.Span<T> is a new value type at the heart of .NET. It enables the representation of contiguous regions of arbitrary memory, regardless of whether that memory… Read More: C# – Span »
In many articles and websites, there are many examples of how Dapper is faster than EF to select data in a database.In this post instead, I want to check if Dapper is faster than EF for some CRUD operations like Insert, Update and Delete.I have this curiosity because I have seen that there is an… Read More: C# – Dapper vs EF for CRUD operations »
In this post, we will see how to use Parallel.For to optimize the performance of our applications.But first of all, what is Parallel.For?“The Parallel For loop is part of the System.Threading.Tasks namespace introduced in .NET Framework 4.0. It provides a convenient way to divide a loop iteration into smaller, independent tasks that can be executed… Read More: C# – Optimizing performance with Parallel.For »
In this post, we will see what LINQ’s SequenceEqual is and how we can use it in our code.But first of all, what is LINQ’s SequenceEqual?LINQ’s SequenceEqual is a method used to determine if the elements of two sequences are equal.It is important to highlight two things:1) it is possible to use any type of… Read More: C# – LINQ’s SequenceEqual »