Entity Framework Core (EF) converts expressions into SQL at runtime. In earlier versions, it was straight forward to get the SQL. In Entity Framework Core 3, you must access the SQL using ILogger. This article explains how to access the SQL generated and gives some example code to access the output of queries made behind the scenes. This article works with Entity Framework Core 3.

RepoDb is a new hybrid micro-ORM library for .NET, designed to cater the missing pieces of micro-ORMs and macro-ORMs

This article presents an alternate way for standard filtering with Where LINQ extension. The result is query has similar performance (perhaps slightly better). But the most important, it doesn’t time out due too many filter parameters.

Easy and optimized way to apply Filtering, Sorting, and pagination using text-based data.

Using ORM for database related work is a common practice in applications developed in the last decade. There are many popular ORM’s. One of the most common ORM’s in the .NET world is Entity Framework.

In this article, we are going to create a web application using ASP.NET Core and React.js with the help of the Entity Framework Core database first approach. We will be creating a sample Employee Record Management system and performing CRUD operations on it. To read the inputs from the user, we are using HTML Form elements with required field validations on the client-side. We are also going to bind a dropdown list in the HTML Form to a table in the database using EF Core.

So you're a dotnet developer and you've heard the hype surrounding graphql, and you think "oh yeah, I just HAVE to try this!". Well prepared to be deeply underwhelmed.

Health check are important, both of our selves, but also of ourrrrr micro-services. This is something I came across lately – a health check of your connection to a database via EF Core context. Let’s check this out!

Often you might be interested in knowing how your LINQ Queries are translated to SQL Database in behind. The best way to profile ASP.NET Core, Entity Framework LINQ queries running on Azure SQL/ On-Premise SQL is to use Azure Data Studio.

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.