Blog Posts with tag "EF Core"

Increase Command Timeout for EF Core Migration Bundles

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 database. They are particularly useful for deploying migrations independently of the source code or development environment, e.g. in production environments.
Using migration bundles simplifies the deployment process as no additional software or configuration is required to perform the migrations. In CI/CD systems like Azure DevOps in particular, they can be executed across all platforms on all operating systems and therefore offer a flexible alternative to DACPAC deployments , which are often dependent on Windows tooling.

Read Blog Post
The well-structured Entity in EF Core

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 purpose of database entities is to provide a structured and efficient implementation for organizing and managing information. By identifying entities, defining attributes and establishing relationships, a coherent and meaningful structure is created that allows data to be stored, retrieved and updated effectively. This facilitates data management and analysis in applications and systems.

Read Blog Post
Re-use EF Core Expressions to avoid redundant queries

Re-use EF Core Expressions to avoid redundant queries

I often see snippets in EF Core code reviews such as the following:

1dbContext.Users.Where( user => user.Id == id );

The query filter user => user.Id == id is contained directly in the Where - often not just in one place but sometimes in dozens of places. Here I ask myself: why is this not simply outsourced to a central place? It’s so simple!

Read Blog Post
Better Code with custom Strong-Id Types

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 is however fundamentally different. In principle, this includes all handling of Ids or other essential values that have a logical meaning.

Read Blog Post
Value Converters in EFCore

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 and systems. When using Entity Framework (EF Core) , a powerful object-relational mapping (ORM) framework, developers can take advantage of value converters to simplify the process of converting data types between applications and databases. . This blog post explains the concept of value converters in EF Core, their benefits, and how to effectively use them in your projects.

Read Blog Post
Create a Fulltext Catalog with EF Core .NET Migrations for MSSQL

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 database. A full-text index is a special type of index that is used to support fast, full-text searches of large amounts of text data. It enables users to search for words and phrases within a column of text data in a table, and returns rows that contain the search criteria. Full-text indexes can be created on columns of data that are stored in character data types, such as char, varchar, and text.

Read Blog Post