What happen in the background when we execute any query from the .net application. I want to know the following particulars.
- How providers take a query and send to DB Server and again fetch the data.
- What kind of memory it utilizes while fetching and sending data.
- What is base behind the providers.(like how they interact with db and application)
EDIT
I am expecting the theoretical answers and do not expect depth technical description as it is not possible to cover here. Also you can share links for the same. Thanks in advance.