Thread by @mwaseemzakir

💡 Life of Query in EF

𝐒𝐭𝐞𝐩 𝟏 : The LINQ Query is processed by EF Core and build an representation that is processed by database provider, and the result is cached later on so we don't need to process it every time #dotnet

See thread 🧵⏬

𝐒𝐭𝐞𝐩 𝟐 : The result is passed to the db provider and db provider identifies which parts of query can be evaluated in db, these parts are then translated into query language (e.g. SQL) after that translated query is sent to db and db returns results (but not entity instances)

𝐒𝐭𝐞𝐩 𝟑 : For each item we check if it is tracking query EF checks the data in existing change tracker if found relevant entity is returned else new is created, its change tracking get set up and it is returned

For non tracking a new entity is always created and returned.

𝐖𝐡𝐞𝐧 𝐪𝐮𝐞𝐫𝐢𝐞𝐬 𝐚𝐫𝐞 𝐞𝐱𝐞𝐜𝐮𝐭𝐞𝐝
When you write a LINQ query it build in memory representation until you call following :

✔️Iterating the results in a for loop

✔️Using an operator such as ToList, ToArray, Single, Count, or the equivalent async overloads.
#dotnet

If you like it join family of 550+ Software Engineers via my Newsletter : lnkd.in/dNHxJGRG
#csharp #dotnet