What is the best way to retrieve data from a database?

Question

C++ / C#

What is more optimal in terms of the complexity of the query to the database, the speed of its execution and the memory occupied after the query is completed?

Such a request:

var itemName = dbcontext.Items.Where(i => i.id == 1).Select(i => i.Name).FirstOrDefault();

Or like this:

var itemName = dbcontext.Items.FirstOrDefault(i => i.id == 1)?.Name;

Answer 1

It is desirable to find out what kind of query is formed in the database. You will find out which one is being formed - you will see which one will be more optimal.