Advanced Usage of MSSQL Indexed Views in EF Core
In the world of Microsoft SQL Server, views are a powerful tool for simplifying complex data queries. Simple views offer no real performance gain but
Increase Command Timeout for EF Core Migration Bundles
EF Core Migration Bundles are standalone executable files that contain one or more Entity Framework Core migrations and can be applied directly to a
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