How does Entity Framework Core store data?

Question

C++ / C#

Hello!

I want to make a selection from the database using some criteria to check users and return some list with the corresponding users. During this, I was wondering how does EF Core store data about these users?

Purely technically, data is stored in database tables, and when we use it, it moves to RAM, everyone knows that. But that's why there is a database to make a selection from it, and not store 100,500 users in your RAM.

How is it, where and how is the database data stored when using EF?

Answer 1

Entity Framework Core does not store data.
Only the result of the query execution is loaded into the RAM (the same 100500 users, if the selection was not limited)
When you make a new selection, they will be loaded again.
Computers have not yet learned to work without RAM.