Sometimes we have to perform several queries to the database, put the results into memory, and then process them as needed. For example, we have a Supplier table and a Customer table. Both tables have a substantial amount of data. We want to combine existing Supplier and Customer data with specific criteria. Generally, we will perform two queries sequentially: query to the Supplier table first, then query to the Customer table. The...

Entity Framework Core is recommended and the most popular tool for interacting with relational databases on ASP NET Core. It is powerful enough to cover most possible scenarios, but like any other tool, it has its limitations. Long time people said (not without reason) that Entity Frmaework does not match high load systems and for these scenarios it is better to use Dapper. But time goes by and Entity Framework...

I've recently gotten into using Docker in my development cycle and I'm really enjoying how much of a wonderful tool it is. One thing that always used to be a pain was setting up a development server to run SQL Server. Now with Docker, I can just spin up a Docker container and I instantly have a SQL Server ready to go. I recently wrote a blog on Getting Started with...

Hi everyone, this article include encrypting your database columns with EntityFramework. Your database providers can be MSSQL or PostgreSQL. Considering that some database columns contain confidential data, it is of great importance that the data is encrypted in case of capture of our database. In this article, it will be ensured that your “string” type data is kept encrypted in the database and can be displayed automatically by decrypting the relevant data...