LINQ is a powerful querying tool for .NET applications. There are certain techniques to follow when writing queries to make sure they run quickly and effectively. The following are a few things to consider when aiming to improve the performance of LINQ to Entities.

Basic and advanced samples - simple 'Hello GraphQL!' example based on console version from GraphQL for .NET on GitHub, but using ASP.NET Core, Entity Framework Core and some best practices, patterns and principles. Advanced - GraphQL queries and mutations with full 'Star Wars' database

In this post, we will see one awesome EF Core 2.1 feature which is DBContext pooling.

how we can leverage the various multitenancy configurations inside EF Core by leveraging a new EF Core 3 feature called Interception of Database operations.

Lets talk about configuring your Entity Framework Core DbContext for a moment. There are several options you might want to consider turning on.

We are going to learn about actions that modify the database content (Create, Update, Delete).

We are going to learn how to access the database via EF Core and how to read the data from it by using different query approaches.

In this article, we are going to learn how to configure PostgreSQL, a popular and reliable open-source relational database, in our .NET Core application, and connect it to Entity Framework Core to utilize its full potential.

With the Repository pattern, we create an abstraction layer between the data access and the business logic layer of an application. By using it, we are promoting a more loosely coupled approach to access our data from the database. Also, the code is cleaner and easier to maintain and reuse. Data access logic is in a separate class, or sets of classes called a repository, with the responsibility of persisting the application’s business model.

Entity Framework provides support for executing raw SQL queries against the database. This feature is available in Entity Framework Core as well. Such raw SQL queries can return entity types or query types (from EF Core 2.1). This article presents a discussion on how we can work with raw SQL queries in Entity Framework Core.