New Data Annotation attributes with .NET 8
With .NET 8, the System.ComponentModel.DataAnnotations Namespace has been revised and some new attributes have been added that have been requested by
The well-structured Entity in EF Core
A database entity represents an identifiable entry, often also things from the real world, which are to be stored and managed in the database. The pu
Re-use EF Core Expressions to avoid redundant queries
I often see snippets in EF Core code reviews such as the following: dbContext.Users.Where( user => user.Id == id ); The query filter user => u
Easy InMemory Unit Tests with EFCore and Sqlite
Unit testing is a type of software testing that is performed on the smallest unit of a software application, called a "unit". A unit can be
Better Code with custom Strong-Id Types
In many software architectures the problem exists that there are methods, which are specified a multiplicity of type-same parameters, whose meaning i
Value Converters in EFCore
In the field of software development, data transformation plays a key role in ensuring that information flows seamlessly between different components
Multi Query Selects with EF Core
Often there is a situation where you need to load several pieces of information from a database or table at the same time in order to display certain
Difference between Add and AddAsync in EF Core
Using Add or AddAsync in Entity Framework Core can be a little confusing, especially for those new to working with databases and ORMs (Object-Relatio
Create a Fulltext Catalog with EF Core .NET Migrations for MSSQL
A full-text catalog in Microsoft SQL Server is a specialized storage that is used to store and manage full-text indexes for one or more tables in a d
Entity Framework 3 - Migrations
Install EF Core 3 Migration tools The tooling of the Entity Framework Core Migrations comes via NuGet (and dotnet tooling). dotnet tool install --glo
Unit Testing with Entity Framework Core 3
This post covers the basic structure for unit tests with Entity Framework Core. Note: Unit tests are only there to test the respective logic. Unit t